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
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.
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.