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
Can we have top / bottom N filter just above the visual in the report page for easy navigation for selection of Top / Bottom N filter. This feature is available in Tableau so that people migrating from Tableau to Power BI should have the same experience instead of selecting the visual and navigating to the right filter section for applying filter. Thanks in advance.
RE: Top N Filters
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:
https://www.youtube.com/watch?v=wKfPS1yZfE0
Thanks
RE: Top N Filters
I'd like to be able to filter TOP N dynamically, taking a value from a slicer. The TOP N filter seems to accept only a hard-coded value.
RE: Top N Filters
I'd like to be able to add a measure (the selected value from my TOP N slicer) as the value (instead of a hard-coded number) in the TOP N filter.
RE: Top N Filters
Avi Singh shows a workaround here
https://www.youtube.com/watch?v=wKfPS1yZfE0
RE: Top N Filters
Top N and All other
Provide the ability to display 'everything else' on one row when using the Top N filter in a visualization. This is a standard reporting view for a lot of people in our company and we have to use workarounds to get it to display, but then it can't be filtered or drilled into without causing all sorts of messy displays.
RE: Top N Filters
The Top N function is great but you need to add the ability to add "All Other" and Overall Total to capture the full way in which folks look at data. Even better would be to add automated but adjustable functionality so you could have Top N / Next X / Next Y / Next Z / All Other / Overall Total. Functionality needs to be sensitive to slicers and cross filtering as well as additional metrics in the table.
RE: Top N Filters
Slicer that allows for top n e.g. 10, 50, 100 etc. and not at page filter.
RE: Top N Filters
Please add TOPN with rest in Others
RE: Top N Filters
Please add feature: 'Sort by value (ascending/descending)' in Visual level filters.
Currently, the 'Visual level filter' feature allows me to sort items by name only, and not by value.
Example to demonstrate: When I have my expense report, I would like to filter out my Top N items. Currently, these Top N items can be sorted only alphabetically. Whereas, I would like to have a feature where the Top N items can be sorted in either ascending or descending order of the "values" of the items.