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