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 (50)
- Merged Idea (11)
RE: Add others options to TopN Filter
I'm working with big numbered "legend" dimensions
Like 133 Agents or 1030 items models.
I'd need to be able to show the first X by ranking and then group the others as "Other".
For now the only way i found was by adding a column but that is static solution. I'd like to be able to make a pie with first x items and one "other" that is responsive to filters like nation or date or client etc..
I can't see a way out except by let the visual handle it but for now they can't
RE: Add others options to TopN Filter
For all visuals we need the option in TOPN filter type, inside the "Show items:" dropdown box, the "Top + "Others"" and "Bottom + "Others"" options, so when a user specifies, for instances, "3" the visual should show the first or last 3 label and besides a 4th label, grouping the rest as "Others" for all kind of visuals... You should keep the "Top" and "Bottom" options as well... Best regards
RE: Add others options to TopN Filter
Works in many other tools, so this is really needed.
RE: Add others options to TopN Filter
I'm surprised this has not received more traction.
There exists numerous articles and blogs guiding people how to achieve this (in a very convoluted way), so the demand is surely there.
Please do merge with the other similar "TopN + Others" requests to give it the weight it deserves.
RE: Add others options to TopN Filter
It´s very necessary this functionality, do this with DAX it´s very complicate. Other BI tools have this functionality with a simple check box.
RE: Add others options to TopN Filter
It´s very necessary this functionality, do this with DAX it´s very complicate. Other BI tools have this functionality with a simple check box.
RE: Add others options to TopN Filter
The key here is that the group is dynamic. The group by feature is a static grouping. That does not work for a dynamically filtered dataset. An option to display TopN + All other is what is needed.
RE: Add others options to TopN Filter
This is an Excellent Idea, I came to add it, but I'm glad someone already has!