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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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/...

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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/...

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.