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
Will it be here by the June update?
RE: Top N Filters
Tentative, when it will be available?
RE: Top N Filters
Thank you
RE: Top N Filters
would be great if could implement this into a pie chart too. For instance, show top N in the pie chart and create an "other" category for others that don't fall into Top N. Top N could be weighted by another field and the Top N categories refreshes as the population changes
RE: Top N Filters
add a bottom n while you are at it for least performing ...
RE: Top N Filters
Cool! I just hope that it gives us the same level of flexibility to handle ties that we have when using the RANK function.
Also would it work correctly if we split a column chart into stacked legends?
RE: Top N Filters
Really useful Excel filtering tool, looking forward to seeing it available in BI!
RE: Top N Filters
Great News! Hopefully we can get it soon?!?! It's power of PowerBI - Nirmal Jain Beyondkey (6+ Yrs Experience in BI)
RE: Top N Filters
Thanks for your feedback! \0/
RE: Top N Filters
Awesome. looking forward for this.