Donut chart 'other' grouping w/ slicer

[mfanalyst]

Hello,

I am trying to find a way to group smaller categories together into an "other" category in a donut chart that will dynamically adjust with a slicer. For example, with the below data set (snip 1), let's say I want to group anything below 10% of the total spending into an "other" category. Using a slicer, this would include categories C, D, E, F, G, and H if I select all departments (snip 2) but would include categories A, D, E, F, G, and H if I only select the green department (snip 3). How do I do this?

Snip 1

Snip 2

Snip 3

Thank you for your help!

[Anonymous]

Hi mfanalyst,

Is there any progress on this issue?

Please remember to update this thread if you have any progress.

Thank you for your understanding.

[amitchandak]

@mfanalyst , refer if this can help

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
https://medium.com/microsoft-power-bi/power-bi-topn-others-8b094203a306