Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 46 | |
| 41 | |
| 20 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 69 | |
| 32 | |
| 27 | |
| 26 |