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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
genashpuryk
Helper I
Helper I

Per column row subtotal

Hello fellows! I need your help with subtotal/grand total in matrix:

genashpuryk_0-1718182391607.png

 

I have this matrix and a total at the bottom. Is it possible to turn of subtotal for "price" part of matrix? I tried various things, but nothing fits me as perfectly as I need. If possible, help me to find approach. 
Thank you!

1 ACCEPTED SOLUTION
Uzi2019
Super User
Super User

Hi @genashpuryk 

Unfortunetly no. 

 

See if you have hierarchy in Row like Category> sub category > product 
so you can disable sub row total but complety on product level or sub category not on specific product.

 

Similarly if you have hirrachy at column part of a matrix then again you can enable and disable the sub total of column but not part of it.

Uzi2019_0-1718182784516.png

 

see if i remove subtotal then all the subtotal will remove not specific part of an account 

Uzi2019_1-1718182856602.png

 

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

2 REPLIES 2
Uzi2019
Super User
Super User

Hi @genashpuryk 

Unfortunetly no. 

 

See if you have hierarchy in Row like Category> sub category > product 
so you can disable sub row total but complety on product level or sub category not on specific product.

 

Similarly if you have hirrachy at column part of a matrix then again you can enable and disable the sub total of column but not part of it.

Uzi2019_0-1718182784516.png

 

see if i remove subtotal then all the subtotal will remove not specific part of an account 

Uzi2019_1-1718182856602.png

 

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Thank you! Have a nice day 😌

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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