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
mickey64's avatar
mickey64
Icon for Super User rankSuper User
6 months ago

Instead of fixing the rows and columns, how about adding a matrix that only displays the total value?

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

    Hi Khushboobarai 

    We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

  • 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