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.
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).
Hi Anonymous
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.