Top N Filters
Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
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!
It's a great feature, being able to do TOP N, with N hard coded. Would it be possible to make N dynamic? I'd like to select N in a slicer (e.g. 5 or 10 or 20). There is a workaround using DAX (and RANKX), but as a newbie I'm finding this painful. More details at Avi Singh's video here:
Jorge Gallas commented
Please add TOPN with rest in Others
And the "Show Others" option?
I've seen others as this but is there a plan to create a grouping for "others" outside of the top n #?
Adam Buckley commented
Hi I'm not sure if i'm doing something wrong, but when I publish the report with a Top N filter on a viz. Each time I access the report it looses the filter. How do I make it so it keeps the filter once published?
PLEASE PROVIDE TOP N VALUES FOR EACH PRODUCT BY GROPUING
Nasir Shaikh commented
It would be nice if you add TOPN with rest in "Others".
Yasiel M. commented
I’m not sure if this is the question already asked. But I'm trying to create a simple Table to give me:
-For each "Brand"
-Top X "Lines"
-Based on Y "Measurement"
Is this possible? I'm currently stuck on the part that I tell Power BI "For each "Brand" "
Hi, any plans about grouping the rest into an "Others" Group.
Ignacio J. Guelbenzu commented
I think it is necessary to allow us to group the rest in other group
Why oly one top n filter can be applied in the report?
Marcelo Navarro commented
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.
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?
I love the top n feature. Are there any plans to show the top %?
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
Yannick C. commented
Marcos Fontes commented
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.
Stuart Charles commented
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
excellent, thank you, if you could include the option to show the rest of the data as a row "other" would be great.