Forum Discussion
Show top n entries
How can i show the top 10 items by a measure (like sales) ?
Greg_Deckler
Community Champion
Community ChampionUse the RANK or RANKX function as specified here based on your sales number:
https://msdn.microsoft.com/en-us/library/gg492169.aspx
Then in your pivot table/Power View table put a filter on that Rank is <= 10.
Hello Greg,
Is there a way to do this without programmation?
Using an option in Power BI?
Looks complicated... don't even know where to put the formula!
Cheers & thanks for your answer,
Edouard