Forum Discussion
SarahHuang
4 years agoNew Member
Confusing with Power BI Data Color
hi, recently i meet with a problem when editing "Data Color" of Clustered Bar in Power BI Desktop. I can't find "Advanced Items" under "Data Color", so i can't configure condition format. Could you he...
- 4 years ago
Hi, SarahHuang
When there are multiple value fields, legend is automatically generated to distinguish different fields. So you cannot set conditional formatting.
The workaround is to use other visuals, such as matrix, so that you can apply conditional formatting to the fields.
Or apply conditional formatting to data labels in Clustered Bar.
Or create 2 Clustered Bar with one value field.Result:
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_Admin
3 years agoAdministrator
Is the "Data Color" option available only for some versions of Power BI? I don't have it in my formatting panel