on 14 Nov 2016 02:22:53
Add "Others" option to the current TopN feature. That would greatly advance user experience as it allows to compress the data set, highlight the most important insights (e.g. Top 5 Sales), but still gives an overview of all of the data.
Jeroen ter Heerdt (administrator) on 18 Apr 2022 20:22:12
We have considered this as part of other enhancements to filters but need more votes to prioritize it.
- Comments (51)
- Merged Idea (11)
RE: Add others options to TopN Filter
yes, I've got 100s of pie slices & it would be some much easier to show the top 5 & group everything else into "other"
RE: Add others options to TopN Filter
would love to see this feature added
RE: Add others options to TopN Filter
Please, please, please.... we need this. Creating a measure to accomplish basic need is killing performance. Salesforce report builder has a check box to group smaller slices! Microsoft we need this!
RE: Add others options to TopN Filter
This idea should be merged with:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20446813-top-n-and-other
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32743936-top-n-dynamic-naming-of-others
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32372755-add-other-to-top-n
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17092042-add-others-options-to-topn-filter
RE: Add others options to TopN Filter
This could easily be used in other visualizations including bar charts, highly agree!
RE: Add others options to TopN Filter
In a similar vane 80/20 filtering is a good way of cleaning up dataset categories with high cardinality but where most data relates to a relatively small subset of category members. i.e. only the top 20 percent of members are shown with the remaining 80 percent rolled up into a single "Other" category.
RE: Add others options to TopN Filter
There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).
I think you should combine this idea with TOP X functionality. I wrote before:
Another suggestion addition to this: the option to make an "other" category. So lets say you want a top 5, you also get the option for a 6th record that summarizes all other categories into 1 "other" category. That way you can better see the composition / distribution of the data.
RE: Add others options to TopN Filter
Agreed, I have data with 25 categories, but I only want to see 5 slices in a pie chart and group the smaller slices into "other". Currently I can only see all 25 slices and it's not usable.
RE: Add others options to TopN Filter
Also would like something similar to SSRS threshold
RE: Add others options to TopN Filter
This would be very useful!!