Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
Chris2B
Helper I
Helper I

Grouping Others

‎10-21-2023 03:52 PM

Hi I am trying to get some help with my Power BI Graphs please. I am trying to get data which is shown on the left as product name. I have then ranked it using the financial YTD values from largest to smallest descending. I have then used the top 20 and others to display the top 20 products as their individual names and for the remainder products to display as OTHERS.

Using a pivot table I have summed up all the OTHERS financial YTD and I have then used a pie chart graph to display the individual products as well as their financial ytd values and I have summed all of the others individual financial ytds to povide a grouped segment of the pie. This is all done in Excel how do I know manage the same outcome for a pie chart in Power BI?

KR,

Chris

 

Chris2B_0-1697928595245.png

 

Labels:
Message 1 of 4
654 Views
0
1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

‎10-21-2023 09:32 PM

Hi @Chris2B 

Please refer to the linked guide :

https://www.youtube.com/watch?v=JLK2e0k8OBE

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Message 2 of 4
625 Views
0
3 REPLIES 3
Chris2B
Helper I
Helper I

‎10-30-2023 03:11 AM

Thank you this had helped me!

Message 3 of 4
577 Views
Ritaf1983
Super User
Super User
In response to Chris2B

‎10-30-2023 03:13 AM

@Chris2B  glad to help 🙂

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Message 4 of 4
576 Views
0
Ritaf1983
Super User
Super User

‎10-21-2023 09:32 PM

Hi @Chris2B 

Please refer to the linked guide :

https://www.youtube.com/watch?v=JLK2e0k8OBE

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Message 2 of 4
626 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All