Forum Discussion
Data Color Formatting not working properly
Hi Anonymous ,
To understand the problem more deeply,it would be best to provide a pbix-file containing the sample data.
You can also try to create measure and use conditional formatting field value :
Color = Switch(true(),
[value_measure] <=2.2&& [value_measure]>=0.9 ,"green",
[[value_measure] <0.9&& [value_measure]>=0.6 ,"yellow",
[value_measure] <0.6&& [value_measure]>=0 ,"red")
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am still experiencing where one random bar is not being formatted with the correct color. I did make sure my formatting was as was suggested above. Here is a screenshot from this morning:
The circled value should be colored red and not yellow.
- V-lianl-msft4 years agoCommunity Support
Please provide a sample pbix after deleting sensitive data to let us know your scenario better.https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216