Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |