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
It would be great to have a top N slicer. same as available in the visuals filters. But as a slicer in the dashboard. Sometimes you want to slice a particular chart or series of charts by top 5 clients/ products etc, and the users are not aware of the fact that they need to open the right filters pane for that.
RE: Top N Filters
It would be great to take this a bit farther:
- Show the top/bottom n as individual members and group all other
- Show the top x % as individual members and group all others
- Show individuals until the other group is less than the largest individual member
- Group by % (top 2%, next 18%, remaining...)
RE: Top N Filters
to solve this for example https://kohera.be/nl/blog/business-intelligence-nl/power-bi-ranking-group/
RE: Top N Filters
If I select a top 5 for example, I want also see the Total amounts for the other products. If possible I want this dynamic. So in my table I see the top 5 and “others” with the amount that is left ( Total amount - top 5 amount)
RE: Top N Filters
Please add Top N filter support for both page level filters and slicers.
RE: Top N Filters
Top N filter is available as a visual level filter, but not as a report level filter. It would be much simpler to automatically filter an entire report to the current month by added a Top N filter to the report level filters.
RE: Top N Filters
Please provide a option to select top / bottom N values in bar charts based on the dimensions.
RE: Top N Filters
Top N Slicers
Create a Slicers that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
Similar to "Top N Filters". But we need this option in the Report visual for some of our customers.
RE: Top N Filters
I think it is necessary to allow us to group the rest in other group
RE: Top N Filters
Why oly one top n filter can be applied in the report?