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

This is great help so far! I have added the measure and am struggling to choose this as the 'Based on Field' under the advanced controls of conditional formatting. There does not appear to be an issue with my measure, but I am assuming something has to be wrong. Can you help me see what it is?

 

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

To use color codes in measures tyou need to have the codes with an hashtag and the six digit code, on the first colour you only have "FF0000" you need to had the # so it would bve "#FF0000".