ConnieMaldonado's avatar
ConnieMaldonado
Icon for Responsive Resident rankResponsive Resident
8 years ago
Status:
Needs Info

Column Width in Matrix Resizes Even When Auto Size turned OFF

 

 

I have a matrix within a report and have adjusted the columns width the way that I want them. 

 

 

 

 

 

 

 

 

 

Auto Size is off, word-wrap is on:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When I move to another tab in the report and then move back to the matrix, the columns are auto-sized.  This is driving me nuts.  I searched the forums, and it seems there was an issue fixed back in October, but it is not working.  Any help would be appreciated!  Thanks.

 

 

 

 

 

7 Comments

  • ConnieMaldonado's avatar
    ConnieMaldonado
    Icon for Responsive Resident rankResponsive Resident

    I have a matrix within a report and have adjusted the columns width the way that I want them. 

     

     

     

     

     

     

     

     

     

     

    Auto Size is off, word-wrap is on:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    When I move to another tab in the report and then move back to the matrix, the columns are auto-sized.  This is driving me nuts.  I searched the forums, and it seems there was an issue fixed back in October, but it is not working.  Any help would be appreciated!  Thanks.

     

     

    • v-haibl-msft's avatar
      v-haibl-msft
      Icon for Microsoft Employee rankMicrosoft Employee

      ConnieMaldonado

       

      Could you please try the workaround below to see if it works?

      Recreate a new Matrix with the same fields, but dragging them in the order preferred (dont reorder after creation).

       

      If issue persists with above workaround, please try above steps until 11/19/2017. A related fix will be deployed at that time.

       

      Best Regards,
      Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have experience this same issue with the total column in a matrix.  All other columns seem to remain fixed as intended; however, when a new slicer value is selected and the dependent matrix refreshes the grand total column on the matrix usually gets crunched down so that the height of the entire matrix exceeds the alotted space (since row heights get doubled).  It's quite annoying because you have manually adjust the total column each time you want to look at new data.

  • Anonymous I have the same issue with my Totals Column. Did you ever find a fix?

  • ConnieMaldonado's avatar
    ConnieMaldonado
    Icon for Responsive Resident rankResponsive Resident

    This was some time ago, and the Auto size width works now:  Click the matrix visual, select Visual on right hand side, Column Headers, Options - Turn off "Auto-size width".

  • ConnieMaldonado  When my slicer modifies the totals, causing the value to become blank, the column width automatically reduces to a narrower size, although "Auto-size width" is switched off. Then once the values return on another slicer change the column has to be manually resized.