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 10 Jul 2020 16:04:36
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!
- Comments (264)
- Merged Idea (1)
RE: Top N Filters
how to get value entered in date filters?
RE: Top N Filters
I also want to use the Top N Filtering. I have a data column which varies daily/weekly. And I want my report to show only top 5 rows (in count). I cannot do manual filtering every time the data varies.
Can anyone help?
Please reach me at muhammad.hassan@techlogix.com
RE: Top N Filters
NOW.
RE: Top N Filters
I would like to limit or filter graphs to show the top 10 customers, for example, or the bottom 10.
RE: Top N Filters
This is basic for Self BI. As a BI developer, I can create a metric. But for a business client that doesn't anything, this is basic.
RE: Top N Filters
CRITICAL!
RE: Top N Filters
Why no update from PowerBI team?
RE: Top N Filters
As all my fellow posters, I agree... we need this very much. This is crucial when making meaningful reports
RE: Top N Filters
This is a really important feature that is missing that will make all sorts of things easier to do. Not only will it be useful for looking at tables of the top x things but it will also should allow an easy way to show the latest data as top 1 of dates should show the latest data point without having to worry about a DAX measure for this.
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.