Forum Discussion

Giada_Togliatti's avatar
Giada_Togliatti
Post Patron
6 years ago

Matrix formatting

Hi,  is it possible in matrix to fix the height and width of every cell to have all of them equal?  
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Giada_Togliatti , I did a quick check, no option. But you can darg like excel and change the width of the column. Height will depend on font size

  • Giada_Togliatti's avatar
    Giada_Togliatti
    Post Patron
    6 years ago

    amitchandak , I've already tried to do it manually but every time I open the pbix I see the default width, I should have something fix and equal to all the cells

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi Giada_Togliatti ,

       

      What you can do is. Set the column header width manually in your matrix visual.

      Then under Format options --> Column Headers --> Turn off "Auto-size column width" option

       

      This will retain your manual column width whenever you open you pbix file.

       

      Thanks,

      Pragati

       

      • Giada_Togliatti's avatar
        Giada_Togliatti
        Post Patron
        6 years ago

        Pragati11 I have switched "auto-size column width" to off.,  but if I change the slicer the width changes