Forum Discussion
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
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
3 Replies
- Chris2B
Helper I
Thank you this had helped me!
- Ritaf1983
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