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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Chris2B
Helper I
Helper I

Grouping Others

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

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

3 REPLIES 3
Chris2B
Helper I
Helper I

Thank you this had helped me!

@Chris2B  glad to help 🙂

 

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

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

Helpful resources

Announcements
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.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

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