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
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.
Solved! Go to 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/...
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |