Forum Discussion
Problem with AVG in the Pie/Donut Chart
Hi Guys.
I have a little problem in my report, I have to create several donuts chart, one of each category and showing the average of the rating, this is a summary of my datasource:
The value of the Rating field is between 1 and 10.
The problem is that donut should show the average of the rating and the space until 10 (max value that can have the rating field). For example in the donut for the category Vehicle repair, if the Average of the rating is 6.4, the donut should show this average (red) and the rest until 10 (gray) that is the max value that can have the rating:
Any suggestion? Thanks a lot.
Hi, the thing is that you don't need a pie for that. The visualization to acomplish the requeriment must be a Gauge. Those visualizations will let you add a Max value like 10 and then add the Average for the values to paint its number.
If you want to keep the circle way you can try this one:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381742?tab=overviewIt will automatically make the number a %. If you don't like it try half circle ones or the regular one.
Hope this helps,
2 Replies
- ibarrau
Super User
Hi, the thing is that you don't need a pie for that. The visualization to acomplish the requeriment must be a Gauge. Those visualizations will let you add a Max value like 10 and then add the Average for the values to paint its number.
If you want to keep the circle way you can try this one:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381742?tab=overviewIt will automatically make the number a %. If you don't like it try half circle ones or the regular one.
Hope this helps,