Forum Discussion
Conditional Coloring for Pie/donut Chart
Hi everyone.
I have a little problem, I have to create some donut chart, but the code colours should be based on the value of a field, these is the table:
I have to create differents donut, one for each category, and the Average of rating by each category. The code colour should follow these rules:
If AVG(Rating)<5 then Red
If AVG(Rating) >=5 AND AVG(Rating)<8 Then Yellow
If AVG(Rating) >=8 Then Green
I think that I would need a calculated field with these rules, and add this field in the data colors of the object, but I can´t (or I don´t know) create a field calulated with AVERAGE function.
Any suggestion? Thanks a lot.
Anonymous , check for custom visual. Standard visual not supported yet.
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
5 Replies
Anonymous , As far as I know, conditional formatting is not yet supported on the pie or any other visual that use a legend.
Anonymous , with table visual you can create a color measure, like
Switch(True(),
AVG(Rating)<5 ,"red",
AVG(Rating)<8,"Yellow",
"Green"
)Now in conditional formatting/ background color/ Data color, Under Fx option (Advance) option
Choose - Field value and use this measure.
Refer to these blogs for steps -
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesMy video, that is for unichar and color - https://www.youtube.com/watch?v=veCtfP8IhbI