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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 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.