Forum Discussion
Conditional Formatting is in reverse
Hi,
I have a Card visual that i want to show the callout value in green if it is >= 0.9 and red if it is below 1 (100%)
The score is 100% but it is in red not green! What am I doing wrong?
Card Visual:
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.
2 Replies
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.
Thank 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?
