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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Pbiuserr
Post Prodigy
Post Prodigy

TOP N best approach

Hello,

I have a field parameter containing 5 dimensions

For one dimension I need be able to display either full chart or TOP N (lets say TOP 10)

 

How to achieve that? By bookmarks? If yes, then how you drag that once you click TOP10 button, the bookmark always stays at the same one requested parameter while all filters are applied and then you can go back to full display? I dont have much space, so if I can done it in one button would be fantasitc

2 REPLIES 2
amitchandak
Super User
Super User

@Pbiuserr , Create a TOPN measure using what if and keep the value of N very high initially, you can change it 10 to a number as per need. This value can be saved with a bookmark too

 

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

 

 

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

Hi Amit,

Thanks its really interesting. My question is: what if I have in chart (so table in this way) two measures. It filters properly like TOP10 from desired measure, but it left also the ones who have any value in previous one (like Sales Amount and Sales amount LY). It gives me TOP10, but also any other value in axis which got anything in Sales amount LY. Any way to solve that?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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