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
Be sure to bring this into BI Cloud as well!
RE: Top N Filters
Have the ability to easily show only the top N rows in a visualization.
Options : which measure to look at, define N number of rows, group all others in one single row.
RE: Top N Filters
This is easy to do with DAX...
RE: Top N Filters
either top N or bottom N would be great.
RE: Top N Filters
Yes you can do this with Measure but would be nice if filter could just do it for you like in a Pivot Table in Excel.
RE: Top N Filters
Agreed. Filtering by "TOP" with an "Order By" would be most helpful.
RE: Top N Filters
Similar to the Excel Top 10 Feature which only shows the top 100/10/5 items from a table in the visualization.
https://www.youtube.com/watch?v=KkfH2pvI84s
RE: Top N Filters
Do you like bypass? If yes you gonna use RANKX. Top N is a stright feature for report users for which reports are created.
RE: Top N Filters
Some calculated fields may help? See http://ayadshammout.com/2013/02/19/dax-rankx-function-scenarios/
RE: Top N Filters
We should have an ability to filter dataset on the report to show only for example top 5 records. In our scenario where we want to show top 5 queries sorted by execution time, we are able to prepare a table visualization, which shows all queries and their execution time, but not finding an option to filter top 5 queries based on execution time.