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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JimJim
Responsive Resident
Responsive Resident

Matrix - Remove column Grand Total but keep Sub Total

Hi Guys,

 

How do I remove the column grand total whilst keeping the sub total? Here is my matrix:

 

JimJim_0-1661509325103.png

 

It looks like I can't remove grand total without also removing sub total.

 

JimJim_1-1661509439487.png

 

Thanks 🙂

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

Hi @JimJim 

 

You can hide the column as below image
001.JPG

 

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

 

View solution in original post

2 REPLIES 2
PijushRoy
Super User
Super User

Hi @JimJim 

 

You can hide the column as below image
001.JPG

 

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

 

JimJim
Responsive Resident
Responsive Resident

Thank you, it does seem strange that Microsoft don't allow us to simply turn it off. But this hack will do the job 🙂

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors