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.
When I use the above RANKX solution on Desktop and put it in a column chart, it works fine until I add a legend. The filter on ranking goes away. Any idea if Desktop will have some built-in Top N functionality ike Pivot tables do?
ALeefResolver II