Forum Discussion

Khushboobarai's avatar
Khushboobarai
Icon for Helper V rankHelper V
6 months ago

Metrix Visual of Power BI Desktop

Hi, can someone how to freeze the column total of the metrix vsiaul?  so there is 2 kind of sceneario im working with..... 1st the nromal metrix which auto generates the Total of column in the end....
Need Help
Khushboobarai's avatar
Khushboobarai
Icon for Helper V rankHelper V
6 months ago

that will not be dynmic or synked to main metrix as per vertical scroll

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
6 months ago

Hi Khushboobarai 

Currently, Power BI does not support freezing columns in a Matrix visual including the total column. When you have many columns and scroll horizontally, all columns (including totals) will scroll out of view.

 

A commonly used approach is to simulate this behavior by using two Matrix visuals:

 

  • One matrix to display only the Total column (placed on the left)
  • Another matrix to display the remaining columns
  • Align both visuals side by side so it appears as a single table

 

If this feature is important for your scenario, you may consider submitting or upvoting an idea in the Fabric Ideas - Microsoft Fabric Community , as it’s a known limitation and a common request.

  • Khushboobarai's avatar
    Khushboobarai
    Icon for Helper V rankHelper V
    6 months ago

    that will not be dynmic or synked to main metrix as per vertical scrll

     
    • v-aatheeque's avatar
      v-aatheeque
      Icon for Community Support rankCommunity Support
      6 months ago

      Hi Khushboobarai 

      You’re absolutely right  the two-matrix approach does not support synchronized vertical scrolling and can lead to row misalignment.

      Currently, Power BI does not support freezing columns or syncing scroll between visuals, so this scenario isn’t fully achievable today.

      This is a known limitation and raising it in the Ideas forum would be the best path forward.