Forum Discussion
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...
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.
I got it to work!!!
Please do tell us how you got it to work and mark it as an answer to future peep's can take advantage of your genius : )
