Conditional Formatting Rule doing the opposite of what it should

[ArchStanton]

I have a conditional formatting rule that does the opposite of what the rule is, when its below 20%the Border of the Card should be Green otherwise it should be Red. I've had to reverse it to work which is counter-intuitive. The value is based on the green 19.7% figure in the Card which works correctly which is making this a bizarre issue to say the least!

Can anyone make sense why this is happening?

[ArchStanton · Accepted solution]

Thanks to everyone who has replied to this and offered me help!

I just found a manual filter was on the Border, when I removed it the card border behaved correctly (Green <20% RED>20%.

😊

[Praful_Potphode]

Hi @ArchStanton 

Check you DAX output by chnaging the format from percentage to decimal number.whatever number comesup thers is what you can use here(0.197,0.0197,1.97).

you might have to also add <= in first rule or >= in seocond rule, otherwise it will miss some values.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[rohit1991]

Hii @ArchStanton 

Your measure is returning a decimal value (0.197), but your conditional formatting rule is written as if the measure returns a percentage (19.7). Power BI always uses the raw value for conditional formatting, not the formatted percentage shown in the card.

To fix the issue:

1. Check your measure – it likely returns something like:

   % Cases = DIVIDE([OlderCases], [TotalCases])

   This returns 0–1, not 0–100.

2. Update your rule to use 0.20 instead of 20%

   • For green: Min = 0, Max = 0.20

   • For red: Min = 0.20, Max = 1

Once the rule uses the decimal values, the card border will match the card text correctly and the colours will no longer appear reversed.

[ArchStanton]

Hi, that already is my rule and it seems to be working just fine in Desktop but not in the published version:

[amitchandak]

@ArchStanton , the first color should be green and the second should be red to match with number on card. 

I saw the other post too, mean rulesare  working correctly on the outline. Can you share pbix to check