Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.