Power BI

Needs Votes

Add others options to TopN Filter

Vote (313)

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)

on 30 Sep 2021 21:40:53

RE: Add others options to TopN Filter

Be able to add others summary next to the top/bottom X in waterfall chart , and other charts as well

on 30 Sep 2021 21:40:44

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

on 30 Sep 2021 21:40:43

RE: Add others options to TopN Filter

if you have a lot of items to visualize in a pie chart, it would be useful to group under a 'other' slice all the slices that have a percentage value under a specified threshold. the chart will definitely look less messy

on 30 Sep 2021 21:40:43

RE: Add others options to TopN Filter

If I filter data in a table or ring / pie chart, the sums neglect the left out data. There should be an option to sum the rest of the data as "Other".

on 30 Sep 2021 21:40:39

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

Mathias Dalevi on 30 Sep 2021 08:21:49

RE: Add others options to TopN Filter

Works in many other tools, so this is really needed.

Blair Borthwick on 23 Sep 2021 10:13:49

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.

Sebastian Vinaya on 02 Aug 2021 17:46:09

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.

Sebastian Vinaya on 02 Aug 2021 17:45:39

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.

Dan Carpenter on 08 Oct 2020 13:35:57

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.

Merged Idea (11)