Forum Discussion
Conditional Formatting for Min/Max Values in Matrix
This is the measure I ended up using and it worked perfectly as you can see below. (The table was slightly renamed since the original posting of this question.)
Here is the output, just as desired: (Q2 FY21 is now included as time has passed and the financials were finalized.) The numbers blacked out were excluded from the formatting by using the filters in the measure.
Hello MFelix,
Thanks for the tip. I fixed this small error, and this measure is still greyed out when I try to select it as the 'Based on value' in conditional formatting. Any ideas on what to do now?
Hi Anonymous ,
I have used the same measure has you and everything is working properly.
Can youn share the screen of the image of the measure again maybe something has missed me.
You can just barely tell in the second photo that Cond_Format is slightly lighter than the other dimensions and measures. When I hover over it to choose it, it does not select like the others will.
Hi Anonymous ,
the problem is that you are selecting color scale you need to select the Format by Field value:
In this measure you are forcing the result of the measure to be a color code so you need to get the color code that is the measure/field value.
I suspected that was the case. I have switched it to that, and I am able to select the cond_format measure. However, stilll, nothing happens on my table. The values are still all showing as black.
I have tried applying it to all three options (values only, totals only, values and totals).