Help with Pie Chart - Dinamic "Others" group based on ranking

[mcemim]

Hi all!! 

I need some help with a Pie Chart. 

There are several slicers on the page (date, location, consultant, .....), and 17 groups of data (let's call "Product Families"). 

The information to be shown is the total value of each family. 

Depending on the filters applies (slicres), the ranking of the families change. 

I must show the top 5, and aggergate all others on a pie chart (always 6 categories are shown - 1, 2, 3, 4, 5 and others).

Has anyone solved this already? 

I have already a measure that indicates if it will be shown as "Family A" or "Others", but I can't put it on the chart... 

[jdbuchanan71]

@mcemim 

Take a look at this post where the same problem was solved.

https://community.powerbi.com/t5/Desktop/Pie-Chart-Top-5-Rest-named-Other/m-p/738810

[mcemim]

Thank you for the indication!

But somehow, it didn't work for me... 

[dax · Accepted solution]

Hi @mcemim , 

As I know, pie chart need to group on column, but slicer can't work on calculated column, so if slicer will change the rank in column, this can't be achieve currently. One workaround is that you need to use two pie charts to show them, one is top 5, another is "other". You could refer to my sample for details.

Best Regards,
Zoe Zhi

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