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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
skhanna
New Member

Freeze Row Total in a Matrix

Hi,

 

I am new to Power BI and will appreciate any help with my question.

 

So, I have a matrix that tells the Visits for Doctors at corresponding Hospitals, but the row total is not visible as there are many columns in my matrix. Is there any way we can freeze the Row Total Column  so that rest columns are scrollable.

 

skhanna_0-1670927433138.png

Any help will be appreciated!!

 

Thanks!

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @skhanna ,

 

Currently, it is not possible to put column subtotal as first column in Matrix, an idea about this issue has been submitted in the following link, please vote it up.

Microsoft Idea (powerbi.com)

 

As a workaround, you can adjust the size of the matrix, or the size of the font to make the scroll bar disappear.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

fahimvj
Frequent Visitor

Set Stepped Layout to "Off". Its under Row Headers.

Hey @fahimvj ,

 

Thanks for the reply,

However, this feature works for column total(one at the bottom) and not for the row total(one at the extreme right)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.