Power BI Ideas Admin on 03 Oct 2014 07:12:28
Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
Administrator on 14 Apr 2021 09:53:26
I'm very pleased to say we've just released the ability to add TopN filters to your visuals in our October update. More details here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/#analytics Please keep submitting ideas and suggestions for other things we can do in this area!
RE: Top N Filters
When can we expect a filter that allows Top N categories?
RE: Top N Filters
Thanks Kim for planning to add this feature. Waiting for next Power BI update :).
RE: Top N Filters
Also helpful will be the option to show the non-Top N in one bucket called Other (user can customise the bucket name).
Eg.
Site A - 10
Site B - 8
Site C - 8
Site D - 7
Site E - 5
Site F - 3
Site G - 3
Site H - 2
Site I - 2
Site J - 1
If setting it as Top 5 it will show sites A-E. Then there's the option to create "Other Sites" which sits below the Top 5 and shows a total of 11. (Make the size of this box the same size as Site E, so that it does not dominate)
Clicking on "Other Sites" allows you to switch to the traditional unfiltered view of all. And from this traditional view of all, you have the option to switch back to top 5 sites.
RE: Top N Filters
Wonderful!
RE: Top N Filters
That sounds fantastic! Can't wait.
RE: Top N Filters
Awesome, Thank you "PLANNED"
RE: Top N Filters
Thanks for the update. &thumbs-up;
RE: Top N Filters
Great News! Hopefully we can get it soon?!?!
RE: Top N Filters
Hello,
I just wanted to update this suggestion in that the team is currently looking at a couple of approaches and have storyboards they are trialing to see what is the best implementation
RE: Top N Filters
Just trying out Power BI for the first time and I'm pretty shocked to find that this isn't already a filter.