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
This feature is necessary. The RANKX approach is useless if you are using Direct Query, which many real world solutions will because of data sources like Azure SQL Data Warehouse.
RE: Top N Filters
We need this ASAP. Qlik and other tools already have this easy way to filter data.
RE: Top N Filters
also, do bottom N as well, or better yet, allow one to sort
RE: Top N Filters
You can do that with DAX so I don't thing that this is a high priority feature..
RE: Top N Filters
Top % and Bottom % would also be helpful!
RE: Top N Filters
ABSOLUTELY POSITIVELY NEED Top N and 'Rest' as all others ASAP!!!! This is holding back full corporate adoption!!!!!!
RE: Top N Filters
When will the status be changed to Planned? Based on the votes, i whould say its about time. Thanks!
RE: Top N Filters
Just came up with this as a requirement in a report. It's a must have!!
RE: Top N Filters
I agree. Having a top 10, top 20, or even
a top "fill in the blank" would speed up report development. Thank you!
RE: Top N Filters
Yes, TOP N filter is very useful