Automatic Color Assignment in Visual to New Entries

[muhamazh]

Good day everyone,

In our dataset that is updated every week, we have four different color choices i.e Green, Red, Yellow, and Ambiguous. For a column that has all 4 of these, it is easy to manually assign them. But, there are columns where only Greens exist or only Ambigious exist, and whenever a new color is added, it takes the default Blue color irrespective of whether it is Red or Yellow or any other color.

So, is there a way to program the visual in a way as to let Power BI know that hey if you get a Red value in this column, assign Red color to it, and Yellow for Yellows and vice versa?

If there's a way for this, then it'd be great. Thanks

[amitchandak]

@muhamazh , You can set, first 10 color using theme

Also, wherever conditional formatting is supported you can control it using color measure.

Conditional formatting is not supported on visuals having more than one measure or legend

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