Forum Discussion

Gertjan's avatar
Gertjan
Frequent Visitor
4 years ago
Solved

Freeze matrix total column

Hi there,

 

I want to freeze the Total column, which is currently the last column of the matrix visual below. I don't want to scroll to the end every time. How do I freeze the column totals? 

 

 

Thanks in advance!

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Gertjan ,

     

    You could consider to submit an idea about customizing the position of column total.

    https://ideas.powerbi.com/ideas/ 

    There is a workaround but it's a bit of a pain. Instead of using automatic column total, you could create "Total" rows in your data tables put it into values field.

     

    Best Regards,

    Jay

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Gertjan ,

     

    You could consider to submit an idea about customizing the position of column total.

    https://ideas.powerbi.com/ideas/ 

    There is a workaround but it's a bit of a pain. Instead of using automatic column total, you could create "Total" rows in your data tables put it into values field.

     

    Best Regards,

    Jay

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion

    Unfortunately you cannot fix the Column subtotals as of now in Matrix visual. You have to scroll all the way to right to view the column totals.