Grouping Others

[Chris2B]

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]

Thank you this had helped me!

[Ritaf1983]

@Chris2B  glad to help 🙂

[Ritaf1983 · Accepted solution]

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