Skip to main content

Power BI

Needs Votes

Add others options to TopN Filter

Vote (319) Share
's profile image

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 (52)
's profile image Profile Picture

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.

's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:16:11

RE: Add others options to TopN Filter

This is an Excellent Idea, I came to add it, but I'm glad someone already has!

's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:16:10

RE: Add others options to TopN Filter

This feature would also be nice in the Treemap visual!

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:14:57

RE: Add others options to TopN Filter

Salesforce does this with no problem, using a "Max Number of Groups" and it groups the smallest values into its own "other" bucket. This is needed ASAP

's profile image Profile Picture

Gideon Gabriel on 06 Jul 2020 00:13:02

RE: Add others options to TopN Filter

It also looks like there are a number of similar requests that are splitting the voting - this is more needed than this simple number indicates!

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:08

RE: Add others options to TopN Filter

Should be included asap.

Pie charts with 100+ tiny slices look realy bad

's profile image Profile Picture

Kyle Schmitz on 05 Jul 2020 23:52:45

RE: Add others options to TopN Filter

Please do this!

's profile image Profile Picture

David PROVOST on 05 Jul 2020 23:52:35

RE: Add others options to TopN Filter

Our customers can't understand why this is not some native feature. And we do agree at BI dept.

's profile image Profile Picture

Vinicius on 05 Jul 2020 23:47:47

RE: Add others options to TopN Filter

We really need this!

's profile image Profile Picture

Dave on 05 Jul 2020 23:47:36

RE: Add others options to TopN Filter

'+1000 ! We need this

Merged Idea (11)