Forum Discussion
Bar chart / Stacked bar chart / pie chart color based on database field?
Hi crenninger
I have a test and I found the result like yours:
We can't use fx in stack visual if we add legend , and we can't use fx in donut and pie visual.
You may vote up an idea for this function: Condition formatting for measure
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHello
You tried conditional formatting and relied on the number column as such evaluate it and select the color?.
I share the following links:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Ss
This is not exactly what I am trying to do, remember I am looking for Bar char, Stacked Bar chart and Pie chart.
Based on a simple table in PBI see screen shot on what I am trying to do.
I can't find how to attach a PBIx file to this post unfortunately
Here is the table
I hope this helps explain.
Anyone had an idea or is this just not possible?
Hi crenninger
You can try customize theme, and change the color code in Themes colors.
Result is as below.
You can download the pbix file from this link: Bar chart / Stacked bar chart / pie chart color based on field
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
