cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cmagotcuvru
New Member

Fix the total on matrice format

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. 

PowerBI.PNG

Many thanks for your help

 

Best regards

 

Clem

5 REPLIES 5
NikhilKumar
Super User II
Super User II

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

NikhilKumar_0-1606321699367.png

 


Nikhil
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.
NikhilKumar
Super User II
Super User II

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

NikhilKumar_0-1606320875403.png

 


Nikhil
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

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

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