Showing results for 
Search instead for 
Did you mean: 
New Member

Fix the total on matrice format


I am begining on PowerBI

I create a "matrice". However I have a lot of data. A scroll tab appears on the right. I am ok with this. 

However I would like to fix the total as in the "table" format. 

Thus I can search in my tab with the total in the same view. 


Many thanks for your help


Best regards



Super User II
Super User II

It should work the way you want if you enable row subtotals-



Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Yes Yes it is okay I put the subtotal

First Picture : 

It is a matrice with a lot of supplier. There is a cursor. When I am on the top of the matrice I can't see the total

TEST 1.png

Picture 2: I am on the bottom of the same matrice with the cursor. I can see the subtotal

TEST 2.png

Picture 3 I want to fix the subtotal in the matrice As in a "tab"TEST 3.png


I don't know if it is possible in the matrice format

Many thanks in advance

Hi @Cmagotcuvru ,

Could you please provide some sample data and fields/measures which applied on the matrix? And the field which you want to show total value is from fact field or measure? If it is a measure, please provide the related formula. Thank you.

In addition, please check the method in the following link and check whether it can help resolve your problem.

Making Sense Of Subtotals Settings In The Power BI Matrix Visual

Subtotals on Matrix Report

how to display Measures in Matrix Subtotal

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User II
Super User II

Please try by enabling totals in Visualization pane as below image- 



Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Hello Nikhil


I put sub total and total. They appear. However when I scroll down/up I can't see the total. 


I search to "freeze the row with the total"


Many thanks 


best regards

Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors