The “Auto-size column width” option on Power BI Desktop will automatically resize the width of table or matrix columns depending on the value.

What if you want to resize the width of all your columns with the same size without using the “Auto-size column width”? Well, currently there is no automatic way of resizing column width to have the same size for matrix or table visual in Power BI.

I have come across this question a few times now, I did some research to find a workaround and found a good video from Power BI Guy , so I decided to write a blog post about it.

In today’s post, we will go through the steps in resizing matrix columns to have the same size across the table. Lets go through the steps:

Step one: Let’s start by creating a simple report with a matrix visual.

Step two: Create a Measure using the REPT function to resize the columns: REPT(<text>, <num_times>)

Step three: The ” Show on rows” for value is off by default, click to turn it on. Also turn on the “Auto-size column width”

Step Four: Drag and drop the Measure to the Matrix visual to resize all columns like below screenshot. Depending on your requirement, you can specify the width when creating the measure.

Step Five: Save the report and turn off the “Auto-size column width” and save again.

Step Six: Remove the measure from the visual and the size of all the columns will persist including any new column that will be added after report refresh.

Happy reporting 🙂