Setting column sizes in a matrix

[jenmeister]

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!

[Ritaf1983 · Accepted solution]

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