Skip to main content

Power BI

New

'grouping tiny slices in pie chart

Vote (88) Share
marcomiani's profile image

marcomiani on 14 Sep 2015 19:43:33

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

Comments (14)
marcomiani's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:16:11

RE: 'grouping tiny slices in pie chart

This is an Excellent Idea, I came to add it, but I'm glad someone already has!

marcomiani's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:16:10

RE: 'grouping tiny slices in pie chart

This feature would also be nice in the Treemap visual!

marcomiani's profile image Profile Picture

8f648693 b745-42eb-a70f-8a29cc7a2632 on 06 Jul 2020 00:14:57

RE: 'grouping tiny slices in pie chart

Salesforce does this with no problem, using a "Max Number of Groups" and it groups the smallest values into its own "other" bucket. This is needed ASAP

marcomiani's profile image Profile Picture

dd92451e def9-4661-95a7-240ad1c11fec on 06 Jul 2020 00:02:08

RE: 'grouping tiny slices in pie chart

Should be included asap.

Pie charts with 100+ tiny slices look realy bad

marcomiani's profile image Profile Picture

55a2c58f f9e1-4530-a604-d33d00f7e820 on 05 Jul 2020 23:52:35

RE: 'grouping tiny slices in pie chart

Our customers can't understand why this is not some native feature. And we do agree at BI dept.

marcomiani's profile image Profile Picture

3e9222d4 d5d9-46ed-b9a6-f195af801e81 on 05 Jul 2020 23:43:40

RE: 'grouping tiny slices in pie chart

yes, I've got 100s of pie slices & it would be some much easier to show the top 5 & group everything else into "other"

marcomiani's profile image Profile Picture

29153aad 2bcd-4661-92c2-57aa858b980a on 05 Jul 2020 23:40:53

RE: 'grouping tiny slices in pie chart

would love to see this feature added

marcomiani's profile image Profile Picture

bdd18c26 0e5a-4651-8100-d46523f60b0c on 05 Jul 2020 23:25:47

RE: 'grouping tiny slices in pie chart

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!

marcomiani's profile image Profile Picture

1c7e16c1 b2c1-40bf-af85-14fe66f81da9 on 05 Jul 2020 22:55:15

RE: 'grouping tiny slices in pie chart

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

marcomiani's profile image Profile Picture

b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 22:28:49

RE: 'grouping tiny slices in pie chart

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.