'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
David PROVOST commented
Our customers can't understand why this is not some native feature. And we do agree at BI dept.
yes, I've got 100s of pie slices & it would be some much easier to show the top 5 & group everything else into "other"
would love to see this feature added
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!
This could easily be used in other visualizations including bar charts, highly agree!
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.
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.
Middle Brother commented
Also would like something similar to SSRS threshold
This would be very useful!!
you can do it by yourself