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.
- Comments (7)
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!
RE: Add others options to TopN Filter
Please do this!
RE: Add others options to TopN Filter
We really need this!
RE: Add others options to TopN Filter
'+1000 ! We need this
RE: Add others options to TopN Filter
This point is really interesting and needing to cover the 100% of the data.
I frequentely have this request.
Only advanced user can produce a measure in DAX but there is limited possibilities.
This option should be automatically present to have a better overview.
RE: Add others options to TopN Filter
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
RE: Add others options to TopN Filter
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.