Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mehlenbae2
Helper II
Helper II

Top N - percent of total

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?

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.