Forum Discussion
Filter Pie Chart
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 , 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
2 Replies
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
Thank you so much!
