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
It is much needed for presenting insights and summaries . thanks
RE: Top N Filters
Can't believe a BI product is designed without it > Who are my Top 10 customers, products, sales people
RE: Top N Filters
This functionality is available in Excel Pivots. Hoping this to be added in Power BI Visuals.
RE: Top N Filters
Yes please most useful
RE: Top N Filters
Would be a very useful filter
RE: Top N Filters
Need a way from which we can create some visualization for Top n say Top 10 subsidiaries in sales without doing any changes in model. This should also work with live connections.
RE: Top N Filters
To those saying that the RANKX () workaround as described in the link below is a sufficient workaround, I disagree very strongly. This requires the model designer to know in advance exactly which field and measure combination needs to be able to have a Top N filter. This is unreasonable, especially if a report includes many Top N visuals. One of the major promises of the Power BI Service is that the same user need not understand modelling to be able to put together powerful reports.
https://dataonwheels.wordpress.com/2013/09/19/adding-top-10-charts-to-power-view-which-honor-filters/
RE: Top N Filters
As Michiel Rozema stated, you can include the top10 rule via DAX, using the RANKX function
RE: Top N Filters
Top 10 AND Cummulative (eg. Cumulative % of sales, etc.) ...please.
RE: Top N Filters
RANKX is seems to be useful if you're using a calculated column against an entire data set, but if I'm using a filter, for example, wanting to rank within a specific reason, I don't have a way to show TOP N within the scope of that filter.