Forum Discussion

Chris2B's avatar
Chris2B
Icon for Helper I rankHelper I
2 years ago
Solved

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