What am I doing wrong ? Conditional formatting.

[Flexx]

Hello again.

I have a table I want to color according to status of the job, but when I apply conditional formatting, only some of the cells are colored correctly.  Seems like yesterday this was working correctly, but today when I opened the report again, it was not.

any ideas?

[amitchandak · Accepted solution]

@Flexx , Can you create it as a measure, in the same formula use max('Job'[so status])  and create it as a measure

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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...