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
We should have an ability to filter dataset on the report to show only for example top N 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.
RE: Top N Filters
"Top 10" is so easy rather than creating new Measure = IF ( HASONEVALUE( .. ), RANKX( ALL (...) , CALCUATE ( ... ) and Filter.
RE: Top N Filters
You can do this already with RANKX () function. Atleast I have used this.
RE: Top N Filters
Currently the only way to successfully develop against large data sets is hide them behind views. The within the view you use TOP N to limit the rows during development for speed.
By comparison, Tableau has a feature that allows you to select ALL, TOP N or SAMPLE N when building the columnstore which is very useful.