Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to 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
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
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.