Top N - percent of total

[mehlenbae2]

Hi everyone,

I have a few pie charts that show tickets that are breached by other teams. I was asked by leadership to show only the top 5 groups that breach tickets. 

The legend for my pie chart shows Breached Groups (e.g. Helpdesk, Procurement, etc) and the values of the pie chart has a Whole Number count of all of this tickets that are breached (this is from the count column in my dataset). I use Top N for the Breached Groups filter and I get the percent the 5 groups, I need the top 5 groups of the entire data set. Any ideas on how to achieve this?

[amitchandak]

@mehlenbae2 , check if custom label can help

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

You have to create a % of the Total measure for label

Divide( calculate([measure],topn(10, allselected('Fact Jobs'[job_name]) ,[measure], desc)),calculate([measure],allselected()))

or try with TOPN with Others

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