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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
floncla
Frequent Visitor

Remove subtotal from only specific rows in a Matrix in Power BI

Hello,

 

I am working on below P&L matrix and I am trying to get rid or rename the second subtotal called 'GM'. I have already renamed the subtotals as 'GM' but the name is not correct for both of subtotals.

 

The first Subtotal called GM is correct as it represents the Gross Margin but the second GM subtotal is incorrect as it represents the subtotal of Overheads and not the GM.

Either removing or hiding or renaming it would work for me as a solution for what I am trying to achieve.

Is there any way to resolve this?

 

Many thanks in advance for your suggestions!!

 

floncla_1-1676479362044.png

 

1 REPLY 1
ribisht17
Super User
Super User

@floncla 

 

Please check https://community.powerbi.com/t5/Desktop/How-to-remove-subtotal-in-Matrix-for-specific-level/m-p/198...

 

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors