Multiple "Group By" on same datasource

[Gautam12]

Hi All,

We have added SalesLine Table as a data source in Power BI.
Using that we want to show 3 bar charts in Report but grouping will be different. 

Below is my data 

Cust  SalesId	ItemId	Amount	Qty	Compnay
c001	s001	p001	100	2	usmf
c001	s001	p002	300	3	usmf
c001	s002	p001	50	5	demf
c001	s002	p003	300	4	demf
c001	s003	p001	200	2	usrt
c002	s003	p002	12	1	usrt
c002	s003	p003	12	9	usrt
c001	s004	p002	10	10	usmf
c001	s004	p001	8	5	usmf
c001	s004	p005	5	1	usmf

Using this data I want to show 3 bar charts.

1. Sum of Amount, Group by Customer and Company
2.  Sum of Amount, Group by SalesId and company
3. Sum of Amount, Group by item and company

Please suggest me how to achieve this.

Thanks
Gautam

[v-juanli-msft · Accepted solution]

Hi @Gautam12 

If you'd like to create three charts to show that goal, you could add "Compnay " as Axis field, add "Cust"/"SalesId"/"ItemId" as Legend field, add "Amount" as Value field.

Best Regards

Maggie

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

[Gautam12]

Hi @v-juanli-msft 

Thanks for your reply.
Let me try this.

Thanks 
Gautam