Dynamic Pie chart by grouping smaller groups under "Others"

[Anonymous]

I have a pie chart which shows data by client and their %. How do I group clients showing less then 2% in the chart by bringing them under one as "Other" . When I select a range from date filter it would not change or clients with more then 2% moves under "Others"

[Anonymous · Accepted solution]

Hi @Anonymous 

You need create a calculated column to replace category in Pie Chart .

column = IF('Table'[Value]<2,"Others",'Table'[category])

The result is as shown :

Then put the column field in Legend , put Value field in Values .You can see the result below .

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

[Anonymous]

Group Smaller Slices with condition in Pie Charts
I would like to group the small slices of a pie chart with one condition, when the percentage of total is less than 2%.