Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now

muellera1995

Add others options to TopN Filter

Submitted by on ‎11-13-2016 06:22 PM
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.
Status: Needs Votes
See more ideas labeled with:
54 Comments (54 New)
Comments
pbiideas1
New Member
‎07-05-2020 05:16 PM
This feature would also be nice in the Treemap visual!
Daniel_Carpente
New Member
‎10-08-2020 06:35 AM
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.
svinaya1
New Member
‎08-02-2021 10:45 AM
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.
svinaya1
New Member
‎08-02-2021 10:46 AM
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.
blair_borthwick
New Member
‎09-23-2021 03:13 AM
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.
mathias_dalevi
New Member
‎09-30-2021 01:21 AM
Works in many other tools, so this is really needed.
nishalit
New Member
‎09-30-2021 02:40 PM
I am creating a monthly profitability matrix on top 10 customers and it would be great to have an "other" bucket to represent the customers not in the top 10!
nishalit
New Member
‎09-30-2021 02:40 PM
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
nishalit
New Member
‎09-30-2021 02:40 PM
It would be awesome if you could configure a dynamic 'TopN' group and have Power BI automatically group everyone else 'Not in TopN' into a separate 'Others' group so the values could be displayed in the same chart. There is currently no straightforward way to achieve this.
nishalit
New Member
‎09-30-2021 02:40 PM
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