Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |