cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
runnerpaul Regular Visitor
Regular Visitor

Combining data from two charts into one

Hi,

 

I have the below two charts:

 

charts.JPG

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Combining data from two charts into one

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:

 

a1.PNGa2.PNG

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
hemantsingh Member
Member

Re: Combining data from two charts into one

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

Moderator v-qiuyu-msft
Moderator

Re: Combining data from two charts into one

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:

 

a1.PNGa2.PNG

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,395)