![]() Here, I’ll create a new calculation group, which I’ll call Measure Selection. So, I’ll go to the Tabular Editor under the External Tools tab. Now, what if I want to dynamically select my measure on the report and the conditional formatting will be applied automatically on the Year Over Year (YOY) section? To do that, I’m going to create a calculation group for my Cost, Margin and Sales measures. Using the Advanced controls, I format the colors by Rules based on the measure that I would’ve just created (CF Background/Font). Next, I go to ‘change the background color’. So whenever there is a blank, it won’t be applied here. The BLANK is not readable by conditional formatting. If this is true, I want Sales here if not, I’ll have BLANK. ![]() Here I’m using an IF statement with SELECTEDVALUE onto my Time Intelligence calculation item that would equal the YOY. I’ll call this measure CF Background/Fonts for this example. What if I want to apply conditional formatting to the Year Over Year (YOY) column only? I could do that by creating a specific measure to restrict this column only. Applying Conditional Formatting To A Specific Column So, if I turn the background off, you’ll see that it is applied to all the calculation items. Here, you can see that it’s referencing the Sales measure. To do this, I need to go to the roller paint section, where I’ll find conditional formatting. In this visualization example, I want to highlight the negative values using a lighter color and the positive values with yellow or green color. ![]() Then I’ll bring my Sales measure into the values section. I have already created the Time Intelligence calculation item, so I’ll drag that into the columns section.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |