Conditional Formatting is in reverse

[ArchStanton]

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:

[pankajnamekar25 · Accepted solution]

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 | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[ArchStanton]

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?