Filter Pie Chart

[Nico_Schulze]

Hello together,

I have created a pie chart and filtered it to show only values greater than 5%. But when I apply the filter, my percentage changes. As a comparison with the pictures: The orange part with 31 has a percentage of 21.3% before. After filtering, it has a percentage of 31.3%. But I want it to have a percentage of 21.3% after filtering. Does anyone know how to do this? That would be a great help.

Thanks a lot!

Nico

[Nico_Schulze]

Thank you so much!

[amitchandak · Accepted solution]

@Nico_Schulze , For that you need have you own measure like

divide([measure], calculate([measure], all())

and then you need to use the calculation group to append this to label

Custom label
https://www.youtube.com/watch?v=IH4bcHhxunw
Dynamic Label
https://www.esbrina-ba.com/time-intelligence-dynamic-legend-in-line-charts/

or use TOPN with other

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE