Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Grouping in a pie chart to isolate a single category

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

pie.jpgpie.jpg

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi mgrammas,

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

156.png

When you delete it , it will show like below

157.png

This is by design

You also could design chart like below

158.png

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

159.png

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.

View solution in original post

2 REPLIES 2
dax
Community Support
Community Support

Hi mgrammas,

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

156.png

When you delete it , it will show like below

157.png

This is by design

You also could design chart like below

158.png

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

159.png

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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.