on 2016-11-14 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 4/18/2022 8:22:12 PM
We have considered this as part of other enhancements to filters but need more votes to prioritize it.
- Comments (52)
- Merged Idea (11)
Kristyna Ferris on 2022-01-06 16:43:05
Top N + Others
The Top N filter option in visuals should have a checkbox that allows you to dynamically display an "other" category that groups everything outside the Top N selection. Right now the workarounds require making extra tables and very non-performant measures for larger data models.
Damien Breingan on 2020-08-25 12:37:45
New feature to use a dynamic 'TopN' in charts alongside an automatically created 'Others' grouping.
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.
Matteo on 2019-09-20 22:41:16
Dynamic grouping
Let's say I have a set containing 100 elements and i would like to visualize (either in a table or in graph) the top 6 individually (i.e. by Sales amount) and the bottom 94 as an aggregated "Other" element (by mean, sum, etc. depending on the need).
Rui Monteiro on 2016-02-26 20:57:52
Define maximum elements in TreeMap
Allow defining the maximum elements to show in a TreeMap, allowing to group all other elements in one square "Others". It would then act as a "Top X" chart and include a "Others" element to visualize the Top X weight in the whole set.
Dipak Bhudia on 2020-07-08 04:58:28
Add "Others" section in Pie or Bar charts to reduce noise of many small values
I almost always consolidate small values in Pie / Bar charts into an "Others" Category to reduce the noise and size of charts. It would be great if this was a default property of the Visual. So if any value is below a % or absolute value of the total amount, roll the legend item into Other. Just ...
Kyle Schmitz on 2019-07-09 21:57:41
Make an "other" feature in TopN!
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!
marcomiani on 2015-09-14 19:43:33
'grouping tiny slices in pie chart
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
McNulty on 2016-01-05 23:13:09
Filter - Combine rest of data as "Other"
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 2019-05-15 22:14:55
Others summary next to the top/bottom X
Be able to add others summary next to the top/bottom X in waterfall chart , and other charts as well
Ecoretti Stefano on 2015-09-14 17:22:22
See the last entries by rank as "Other"
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 ...