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

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.

Reply
JohnGo
Regular Visitor

PBI Matrix Row Subtotals - Applying subtotal to specific column

I am trying to get the "Subtotal" or total to total on SO vs "Customer PO Line Number".

It was subtotaling under SO as shown below 

JohnGo_2-1674747380335.png

JohnGo_3-1674747496967.png

 

Then I added the customer PO line to rows and it moved the subtotal to customer PO line. 

JohnGo_0-1674746911710.png

JohnGo_1-1674746934428.png

I have spent sometime messing with Row subtotals and flipping switches and changing drop down boxes to include SO. (fyi: drop down box was on All before) Nothing has helped move the subtotal back to SO. How do I get the subtotal to fall under SO again?

 

 

 

2 REPLIES 2
JohnGo
Regular Visitor

No unfortunately, I have tried that multiple times and in different orders.

 

JohnGo_0-1674748585696.png

 

Padycosmos
Solution Sage
Solution Sage

I think you need to toggle Show Subtotal to On

Padycosmos_0-1674748146122.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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