Combining data from two charts into one

[runnerpaul]

Hi,

I have the below two charts:

Each sales person is a member of a sales group but currently the only way I know how to show data for both is in two separate charts. Is there any way I can show both sales group and sales person in the one chart?

Thanks

Paul

[v-qiuyu-msft · Accepted solution]

Hi @runnerpaul,

Based on my test, you can place both Sales Person and Sales Group field in Pie chart and Donut chart.  You can set Sales Person as Legend and Sales Group as Details. And turn on the legend. See:

You can see each color represents each SalesTerritoryGroup instance, and in each SalesTerritoryGroup instance, there are many SalesTerritoryRegion values. You can have a look at attached .PBIX file.

Reference:

Tutorial: Doughnut charts in Power BI

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[hemantsingh]

Hi paul...

  Have you tred matrix visual ??

          I guess that will solve your issue as per my understanding. You are trying to make a 3 dimensional chart i.e one axis for sales group,one axis for sales person & one for sales. Most of the charts/visual you will find are 2 dimensional. I guess matrix is the only visual where you can take 3 things/commodities into consideration. I may be wrong but this is what i have understood from your requirement.

Regards