Forum Discussion
Group small values in Pie Chart
Hi
Ive created a Pie graph with my dataset and I want to group all my small values together.
Ive seen this posted multiple times but all the solutions refer to adding a calculated column, in my case I need this to work dynamically, so when the date filter is changed the Pie Graph will automatically pick up the Customers that have a market share over 10% then group all the smaller ones as "other" for that selected period. Is there a way to do this?
Anonymous I'm sure that this runs into problems somewhere but try it out. Create a measure:
Percent of All = SUM([Size]) / SUMX(ALL(Table2),[Size])Filter the visual by this measure >.1
Now create another measure:
Other = VAR __Table = ADDCOLUMNS(ALL('Table2'),"__Percent",[Percent of All]) RETURN SUMX(FILTER(__Table,[__Percent]<.1),[Size])Put this measure in Values along with your other column.
1 Reply
Anonymous I'm sure that this runs into problems somewhere but try it out. Create a measure:
Percent of All = SUM([Size]) / SUMX(ALL(Table2),[Size])Filter the visual by this measure >.1
Now create another measure:
Other = VAR __Table = ADDCOLUMNS(ALL('Table2'),"__Percent",[Percent of All]) RETURN SUMX(FILTER(__Table,[__Percent]<.1),[Size])Put this measure in Values along with your other column.