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
So I think I may have found some kind of workaround to my problem but not entirely sure how or why. I tried removing some of the visual level filters on the surrounding charts and then undoing the changes. Although this didn't work, changing the top N value to 30 (from 20) and then applying and then setting back to 20 again and applying seemed to work.
I wonder if it some legacy issue when you try to apply Top N filters to visuals originally created in a previous version of Power BI desktop and some new properties just need to be re-applied.
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
Now that top N and attribute groupings are available, a cool feature would be to allow dynamic group definition based on a value of a measure or attibutes. eg: group top 10 sales products and assign remaining products to others group ...
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
Thank you for the Top N feature released yesterday, this is an essential feature we have been eagerly awaiting for months now.
I used it within a treemap and it seemed to work perfectly initially. However, when I then start clicking on the items in the treemap, the cross filtering in the other charts around the page return blanks, but only for some items not others. If I increase the N parameter, a larger proportion of the items cross filter correctly.
I am applying Top N on the same dimension name used in the "Group" and top N is applied to the same measure used in the "Values".
I've had a good look around to see if there are any other filters that might be affecting it but can't see anything. And if I remove the Top N filter completely it all starts working fine again, albeit with far too many values in the treemap again.
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
RE: Top N Filters
Excellent, Thank you "Top N feature"