Forum Discussion

TheDrDetroit's avatar
TheDrDetroit
Regular Visitor
2 years ago
Solved

conditional formatting colors when comparing values

I'm formatting colums to change colors when compared to a planned value.  If it's lower it turns red, if it's higher it turns green.   When the cells are empty the default to not being less that...
Need Help
  • TheDrDetroit's avatar
    TheDrDetroit
    2 years ago

    With the help of MageVortex this is the DAX that worked:

     

    Color March = IF ( COUNT ( 'KPI' [Actual]  ) = BLANK(), "#FFFFFF", IF ( MAX ( 'KPI' [Actual] ) < MAX ( 'KPI' [Plan] ), "#E68F96", "#BBF4C6" ))

     

    You have to use the hex code for the colors, I made the mistake of not entering a hashtag before the color code and it created an error.  Thanks for your help MageVortex.

TheDrDetroit's avatar
TheDrDetroit
Regular Visitor
2 years ago

It's giving me an error message, it's asking to specify an aggregation, min, max, count, sum

 

MageVortex's avatar
MageVortex
Helper I
2 years ago

Sorry, I forgot to finish the equation, it should have read more akin to:
 IF (  'KPI' [Mar-Actual] =BLANK(), "000000", IF (blahblahblah

Or perhaps a 

0

in place of 

BLANK()
 
That may not help the report I was testing with is my own and set up differently than yours.  If you must use min max or sum, you can just try sum = 0 or something like that. 
Hope that helps.
  • TheDrDetroit's avatar
    TheDrDetroit
    Regular Visitor
    2 years ago

    I tried COUNT and SUM, they're not working, the error message says there are too many arguments for the funciton.  

     

  • TheDrDetroit's avatar
    TheDrDetroit
    Regular Visitor
    2 years ago

    Thank you for your help!