Grouping in a pie chart to isolate a single category

[Anonymous]

I just watched the Power BI training video on grouping and binning, and saw exactly what I want to do, but grouping works a little differently if you only group a single category.  The pie chart below reports sales by country.  I want the chart to display USA, and everything else as Other.  It does change the slice colors to all grey, but it keeps the slice lines and country names.  It should be a single slice called "Other".  It behaves correctly if there are two or more members of the group.  Is there a way other than grouping to group?

Thank you,

MIke Grammas

[dax · Accepted solution]

Hi mgrammas,

When you add field in legend, it will show like that

When you delete it , it will show like below

This is by design

You also could design chart like below

When you click “do to next level”, it will show like below

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.

[Anonymous]

dax,

That worked for me, but it isn't obvious to me why it works.  That's okay, it will hit me some day.  I am just beginning my Power BI journey.

Mike