Forum Discussion
Power ParticipantConditional Formatting is in reverse
Hello ArchStanton
Use DAX measure
KPI Color =
VAR Score = [LatestValue18mths] -- Replace this with your actual measure name
RETURN
IF(
Score >= 0.9,
"#00B050", -- Green
"#FF0000" -- Red
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Super UserHello ArchStanton
Use DAX measure
KPI Color =
VAR Score = [LatestValue18mths] -- Replace this with your actual measure name
RETURN
IF(
Score >= 0.9,
"#00B050", -- Green
"#FF0000" -- Red
)
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Power ParticipantThank you, that worked!
Before I accept and give a like, do you know why this was happening? I have other cards that seem to work but this particular one didn't. I'm baffled as to why this was happening?