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,
Fairly new to powerbi so this may seem like a basic question but I cant seem to get my head around it. I have the following dataset showing order, order type, order category and amount. I want to do 2 things to present my table and chart visual.
1. I would like to do sum based on selected values of order type (multiple values; in this case A+B+C) and separately by D.
2. These sum totals need to be presented by order category in the visual.
Any help is greatly appreciated. Cheers
Sample Dataset:
Order | Order type | Order Category | amount |
123 | A | Shirt | 64654 |
23434 | B | Tee | 21465 |
345 | A | Pants | 56465 |
5476 | A | Pants | 68746 |
547 | B | Tee | 64654 |
342 | D | Shirt | 52465 |
8765 | D | Shirt | 54545 |
48 | D | Tee | 32415 |
2456 | C | Pants | 14533 |
2764 | D | Pants | 45646 |
68576 | D | Pants | 34563 |
Trying to achieve the following:
Solved! Go to Solution.
Hi,
You may download my PBI fille from here.
Hope this helps.
Hi,
You may download my PBI fille from here.
Hope this helps.
Thankyou! It works perfectly. Didnt think of this solution. 🙂
You are welcome.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |