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.
We have a need to show subtotals and a grand total - but also a grand total of each of the subtotal rows. For example we have a series of cities and then a break out of hours worked Reg and OT under each city. We are only getting a Grand total of all the hours but we also need to see a total of all the Reg and then another total of all the OT. This is easy in a pivot table or SSRS. Is this just a limitation of PowerBI matrix?
Solved! Go to Solution.
hi, @tfgardner
If the Reg and OT are the value of one filed. If so, just use drill mode in matrix visual
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
If they are different fileds, you could do unpivot columns in Edit Queries.
In edit queries, select Reg and OT, then unpivot them and use drill mode in matrix visual.
Best Regards,
Lin
hi, @tfgardner
If the Reg and OT are the value of one filed. If so, just use drill mode in matrix visual
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
If they are different fileds, you could do unpivot columns in Edit Queries.
In edit queries, select Reg and OT, then unpivot them and use drill mode in matrix visual.
Best Regards,
Lin
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |