Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hello guys,
Want to know how exactly Power BI assigned Color to visual like Pie chart and Bar chart.
Especially for pie chart, depicted in the picture :
When customize current theme, I noticed I have that color scheme which put as Color 1, 2, 3 up to 8
But when add Pie chart, based on the value of my measure, big to small value, it will not start with Color 1, instead Power BI pick different color for each of the same visual type. If you see in the pict, Pie 1 start with Color 5 in my Theme setting, and Pie 2 start with Color 3. Only order #3 same even so it will sync to what define in my Theme.
Also when it incidently have same value, like the 2nd Pie no 4, how actually Power BI will decide the chosen color.
Is there any logic, or Power BI can randomly choose any color from my Theme ?
Another is if for Bar char, it will choose my Color 1 (which actually what I expected)
Thanks,
Solved! Go to Solution.
Hi @admin_xlsior ,
We have a test, the maximum value corresponds to color 1, the second largest value corresponds to color 2, like this following screenshot.
And if we use two measures, the result is the same as before.
And you can refer this article to see the custom theme.
If it doesn’t meet your requirement, could you please provide more detail about your issue? Could you please provide a mockup sample based on fake data?
It will be helpful if you can show us the exact expected result based on the tables.
Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hi @admin_xlsior ,
We have a test, the maximum value corresponds to color 1, the second largest value corresponds to color 2, like this following screenshot.
And if we use two measures, the result is the same as before.
And you can refer this article to see the custom theme.
If it doesn’t meet your requirement, could you please provide more detail about your issue? Could you please provide a mockup sample based on fake data?
It will be helpful if you can show us the exact expected result based on the tables.
Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
@admin_xlsior , is the first case happening after a filter has been applied or when you drill down.
If not, then log and issue at https://community.powerbi.com/t5/Issues/idb-p/Issues
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
88 | |
74 | |
63 | |
48 | |
36 |
User | Count |
---|---|
116 | |
86 | |
80 | |
59 | |
39 |