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 everyone,
I'm new to PowerBI and I want to create a summary table that has subtotal for each group and a grand total as well (like in the example below). How can I do this in PowerBI?
Thank you!
Origin table:
Hierachy 1 | Hierachy 2 | Month1 | Month2 | Month3 |
X | A | 22 | 31 | 32 |
X | A | 23 | 4 | 5 |
X | A | 23 | 54 | 21 |
Y | A | 23 | 5 | 62 |
Y | B | 23 | 4 | 5 |
Y | B | 23 | 54 | 21 |
Y | B | 29 | 98 | 45 |
Y | B | 12 | 45 | 18 |
Target:
Hierachy 1 | Hierachy 2 | Month1 | Month2 | Month3 |
X | A | 68 | 89 | 58 |
Total | 68 | 89 | 58 | |
Y | A | 23 | 5 | 62 |
B | 87 | 201 | 89 | |
Total | 110 | 206 | 151 | |
Total | 178 | 295 | 209 |
Solved! Go to Solution.
Hi @LinhNguyen
let me know if you'd like to get this one:
Pbix attached.
Hi @LinhNguyen
let me know if you'd like to get this one:
Pbix attached.
Thank you!
Please try Matrix visual
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |