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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
manike
Frequent Visitor

How to align the color on same dimension across different chart?

Hi all,

I am new on PowerBI.
I am working around on different charts with same dataset.
However, it is found that the colour with same category on different chart is different.
For example, I have a fruit dimension with categories - apple , banana, pear.
I have 2 charts - bar chart and pie chart.
In bar chart, I set the colour for apple is red, banana is yellow and pear is green, but these colours setting is not applied for pie chart with same fruit dimension.
Please advise how can I align the colour on same dimension across different charts? It would be crazy if I need to set the colour in the different charts one by one. Thanks.

1 ACCEPTED SOLUTION

@manike , You can use conditional formatting on pie, using it first on the bar and then converting to pie. But that will only work on visuals(other then pie) do not have legend and use only one measure

 

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

 

Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

View solution in original post

4 REPLIES 4
manike
Frequent Visitor

seems didn't automatically sticks to same color for same data with different chart. 

is it limitation for power bi? Thanks.

@manike , You can use conditional formatting on pie, using it first on the bar and then converting to pie. But that will only work on visuals(other then pie) do not have legend and use only one measure

 

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

 

Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

I got this. I learnt a lot from your answer and noted with there are limitation for PowerBi. Thanks.

JirkaZ
Solution Specialist
Solution Specialist

I think that a theme does that automatically and (hopefully) sticks to the same color for the same data. But if you just modify the colors just for one visual, then it's not propagated to the other visuals. 

Feel free to submit an idea though. Might be useful for others as well.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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