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.
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.
Hope that helps.
I tried COUNT and SUM, they're not working, the error message says there are too many arguments for the funciton.