Background color function using "Cell elements" works sometimes, sometimes not

[Anonymous]

Hi there community,

I set up rules for the Background of my table to make it easier to see where the KPI is red and green.

sadly, this doesn´t work for all cells, although the range I set up in the rules should work - and some cells work and some don´t. And I can´t see what´s the reason behind it and what went wrong. can you help me?

These are my rules (its a calculated value)

this is what my table looks like (you can see it sometimes works, sometimes not. and the values where it does not work are in between values that work. I don´t get it)

Any suggestions? 

Thanks!

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

In addition, you can also try to use expression-based mode conditional formatting if rule mode does not work properly:
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , You are using sum of overdue, can you check that by adding that to the table? Prefer to use measure.

You can also create a color measure and use that in conditional formatting using field value option

example

Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3