Forum Discussion
Solved
Donut Chart - dynamic percentage
Hello everyone, This donut chart shows the total of area and the percentage. It shows the correct data. However, when i select one store it shows the right area, but it still shows 100%...
Hi elcamino
When filters are applied, Power BI calculates pie/donot chart percentages based on the total of the visible crows. So, if only a single category is selected, the numerator and denominator are the same, resulting in 100%. Unfortunately, in donut and pie charts, data labels cannot be set to use a separate measure for custom percentages. A workaround is to use Deneb, though this requires some coding.
Please see the attached sample pbix
cengizhanarslan
Super User
Super UserOnce you filter to a single store, Power BI calculates the label percentage against the visible total inside that visual, so that slice becomes 100% of the filtered donut, not 41.35% of the original total.
The practical wokarounds are:
- keep the donut for the area value and show the true percentage in a separate card/measure
- or use a custom visual like Deneb if you want the donut label itself to show your custom percentage.