Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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
@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...
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 112 | |
| 108 | |
| 39 | |
| 34 | |
| 27 |