Fix the total on matrice format

[Anonymous]

Hello 

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

Clem

[Anonymous]

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

[Anonymous]

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

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

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

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

Many thanks in advance

[v-yiruan-msft]

Hi @Anonymous ,

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.

[Anonymous]

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

[Anonymous]

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