Conditional Format Rules Doesn't Work When Filtered

[smather]

Hi there

I have some conditional formatting on the totals (I'd like them to be on both values and totals, took values off because it didn't work when filtered only to find out it doesn't work when filtered for totals either). 

It's a 3 pronged rule and each is different for every column. 

First rule - if it's >= 0 and < 25 then red

Second rule - if it's >=25 but < 55 then yellow

Third rule - if it's >=55 and < 100 then green

Each col has a variation of that rule. And when nothing is filtered, it colours the total correctly. If I filter the months, then they're all green when they shouldn't be. Any ideas?

[v-eqin-msft · Accepted solution]

Hi @smather ,

Please try to create a measure for conditional formatting:

Color Measure = SWITCH(TRUE(),
[10Secs %]>=0 && [10Secs %]<0.25 ,"Red",[10Secs %]>=0.25 && [10Secs %]<=0.55, "Yellow", [10Secs %]>=0.55 && [10Secs %]<1,"Green")

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smather]

@mh2587 that's absolutely perfect, thank you!

[mh2587]

can you share the screenshots 

[smather]

@mh2587  sure!

Apologies, I should've said "it didn't do what it was meant to". The top picture is perfect, until I filter it by month:

[mh2587]

If the values in percentage then put 0.25 , 0.55 and 1 for hundred 

[smather]

Hi @mh2587  - just tried this, and it doesn't format anything 😞