Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional Formatting for Min/Max Values in Matrix

Hi,   I am needing to conditionally format the values in this table to show with red font color if it is the lowest value within the quarter and green font color if it is the highest value within t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

MFelix's avatar
MFelix
Super User
5 years ago

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.