Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SarahHuang
New 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 help to give me some feedback?
1 ACCEPTED SOLUTION

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:

vangzhengmsft_0-1639457464187.png

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.

View solution in original post

7 REPLIES 7
Syndicate_Admin
Administrator
Administrator

Is the "Data Color" option available only for some versions of Power BI? I don't have it in my formatting panel

v-angzheng-msft
Community Support
Community Support

Hi, @SarahHuang 

As @ebeery  mentioned above, remove the legend field and you will be able to set rules for color.

vangzhengmsft_0-1639451843906.png

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.

hi @v-angzheng-msft @ebeery Thank you for your suggestion, but i confirmed there's no field under "Legend". My requiremnt is not to set different color to the bar, it is to display red color with the bar when the value is over standard value.

SarahHuang_1-1639453902991.png

 

SarahHuang_0-1639453889043.png

 

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:

vangzhengmsft_0-1639457464187.png

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.

Thank you very much for your online supporting~

ebeery
Solution Sage
Solution Sage

Hi @SarahHuang , have you added a field to the "Legend" series of the Clustered Bar?  If so, I don't believe conditional formatting is available, since the coloring is already being assigned based on the Legend series value.

ebeery_0-1639109781694.png

 

Exactly coloring is assigned to every value, but i can't find "Advanced controls" under "Color Data" to set up some rules for different color display.

SarahHuang_0-1639121602788.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.