FIX MATRIX COLUMN WIDTH IN POWER BI

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.

In today’s post, we will go through the steps in resizing matrix columns to have the same size across the table. Let's 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.