Add others options to TopN Filter

[muellera1995]

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.

[AlexNYExcel]

you can do it by yourself

[sascha_overdeve]

This would be very useful!!

[ryancawker]

Also would like something similar to SSRS threshold

[stalderj]

Agreed, I have data with 25 categories, but I only want to see 5 slices in a pie chart and group the smaller slices into "other". Currently I can only see all 25 slices and it's not usable.

[mikejarod]

There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented). I think you should combine this idea with TOP X functionality. I wrote before: Another suggestion addition to this: the option to make an "other" category. So lets say you want a top 5, you also get the option for a 6th record that summarizes all other categories into 1 "other" category. That way you can better see the composition / distribution of the data.

[beneuto2]

In a similar vane 80/20 filtering is a good way of cleaning up dataset categories with high cardinality but where most data relates to a relatively small subset of category members. i.e. only the top 20 percent of members are shown with the remaining 80 percent rolled up into a single "Other" category.

[fbcideas_migusr]

This could easily be used in other visualizations including bar charts, highly agree!

[christian_welsc]

This idea should be merged with: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20446813-top-n-and-other https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32743936-top-n-dynamic-naming-of-others https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32372755-add-other-to-top-n https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17092042-add-others-options-to-topn-filter

[Teresa_Fitzpatr]

Please, please, please.... we need this. Creating a measure to accomplish basic need is killing performance. Salesforce report builder has a check box to group smaller slices! Microsoft we need this!

[mkeiper1]

would love to see this feature added