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
Why oly one top n filter can be applied in the report?
RE: Top N Filters
Great feature, but do you want to make it perfect? Allow us to group the non top N records into an "other" group. Then the Total would be displayed correctly and we would be able to see the size of the non top N. SAP's B.O. has this functionality.
RE: Top N Filters
Hello, I was excited to see a Search function for the slicer. However, for some reason when I add in my criteria (in my case "Case Number") I then go to the ... to initiate "Search" and there is no option there. Only "Sort By Case Number", "Export Data" and "Remove"
I've updated to the newest Power BI.
What am I missing?
Please Advise.
RE: Top N Filters
I love the top n feature. Are there any plans to show the top %?
RE: Top N Filters
Great!
RE: Top N Filters
Hi Will,
very pleased to see having an update on this. That'll help us a lot with designing reports.
Could you, within the next releases publish an extension to this feature, that you have a TopN per category filter?
Like I have 3 categories and want for each the top 5 sales, I would need to have 3x5 = 15 items in my table
RE: Top N Filters
I identified a problem in the filter behavior "TOP N" when the report already has other filters. For example, I want to show the 10 players with the best performance, but had a filter for matches > 5. When you apply the "TOP 10" filter, are returned only 3 players, because the filter "TOP N" filters the original data, and not the data already filtered by the "greater than 5 matches." I believe the correct behavior would be the filter "TOP N" respect other filters applied. That is, the TOP N should be the last filter applied, not the first.
RE: Top N Filters
This is great news, thank you! I'm not sure cross filtering is working quite right when Top N is applied to interactive visuals, I've explained the issue here https://ideas.powerbi.com/forums/360879-issues/suggestions/16897216-cross-filtering-using-top-n-on-treemap-returning-b
RE: Top N Filters
excellent, thank you, if you could include the option to show the rest of the data as a row "other" would be great.
RE: Top N Filters
Good job