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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.