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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

TOPN

Hi All,

 

I'm very new to PowerBI, so not sure if this is even the location I need to post to.  I'm having difficulty working with topN.  I have to use topN for one of my charts but need it to associate with all slicers and drilldowns chosen on the dashboard.  Can someone provide any ideas on how to get this to work. 

 

Example, I have 5 charts and 4 slicers on my dashboard.  One chart is supposed to be a treemap showing the top 5 ID's contributing to whatever is drilled down from one of the other 3 graphs AND whatever slicer value chosen.  Is there a way to do this?  OR if this was already answered, can someone point me to it?

 

Thanks!

TP

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , You can use a visual level TOPN filter or create a TOPN measure

 

example

calculate([Net Sales PY], TOPN(2, allselected('Address'[Country ISO]), [Net Sales PY],desc), values('Address'[Country ISO]))

 

refer: TOPN: https://youtu.be/QIVEFp-QiOk 

 

Others

 

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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