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
Would be intereting to get an update on this as top lists are often requested in reports.
RE: Top N Filters
Hi Alex, it has been a while....any update on this feature ?
RE: Top N Filters
Also include an option to display "Others" as a sixth group in the chart. Very useful for Donut/Pie charts.
RE: Top N Filters
Please include paging in reports
RE: Top N Filters
Please do it as soon as possible. I need it so badly.
RE: Top N Filters
When we have this great feature....
RE: Top N Filters
Great youre adding this, this is really important.
Another suggestion addition to this: the option to make an "other" category. So lets say you want a top 5, you also get the option for a 6th record that summarizes all other categories into 1 "other" category. That way you can better see the composition / distribution of the data.
Would be super cool if you have this option in a matrix, and it automatically top X's where the X is calculated based on the height (pixels) of the visual. So a vertically big table would do say TOP 20, and a small vertical table would do TOP 5. And ofcourse the "other" option stated above. I think scoll bars would become obsolete for this visual.
RE: Top N Filters
how can search top n ? have u nay idea ?
RE: Top N Filters
This can be solved by using the rankx function along with parameter tables. You can have a parameter that will allow the user to select the number of items shown, the actual measure they want to see (sales, profit, etc) and pretty much anything else your heart desires. This method is outlined by Collie, Russo, and Ferrari in several blog posts/books.
RE: Top N Filters
We need the Top n filter in charts where the rest will be summed.
When will this feature be implemented? It's a really important feature and there is no workaround to implement this in charts so far. Just for the Matrix table.