Forum Discussion

skhanna's avatar
skhanna
New Member
3 years ago

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.

 

Any help will be appreciated!!

 

Thanks!

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

    • skhanna's avatar
      skhanna
      New Member
      3 years ago

      Hey Anonymous ,

       

      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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.