Forum Discussion

jenmeister's avatar
jenmeister
Regular Visitor
3 years ago
Solved

Setting column sizes in a matrix

Hi everyone, 

 

I'm quite new to Power BI so still figuring out how things function on there. I've been trying to set the columns of my matrices to be exact sizes but cannot seem to find an option to do so in 'Format visual'. I've been using the drag bar that appears at the end of each cell of the matrix to resize but when I re-adjust the date of the slider at the top, all the cells of the matrix stay the same size apart from the 'column subtotal' cell at the end which becomes smaller.

 

 

Is there any way I could either fix the size of the last cell or set a consistent size across all cells so they don't resize when I apply the slider?

 

Thank you in advance for any advice!

 

 

 

  • Hi jenmeister 
    Unfortunately, there is no generic option to fix columns with on matrix.
    But you can modify it with the trick of using the fictive measure and function Rept.

    Please follow the instructions in the attached video tutorial:

    https://www.youtube.com/watch?v=4ZtuifazEHk

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

1 Reply

  • Hi jenmeister 
    Unfortunately, there is no generic option to fix columns with on matrix.
    But you can modify it with the trick of using the fictive measure and function Rept.

    Please follow the instructions in the attached video tutorial:

    https://www.youtube.com/watch?v=4ZtuifazEHk

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly