Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tfgardner
Frequent Visitor

How can we get subtotals with Grand Totals and grand "subtotals" in a matrix

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?

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.