Power BI: How to Change Column Width in Table


Often you may want to change the width of columns in a table in Power BI.

Fortunately this is easy to do by turning off the Auto-size width feature.

The following example shows how to do so in practice.

Example: How to Change Column Width in Table in Power BI

Suppose we have the following dataset in Power BI that contains information about total sales made at various stores:

Suppose that we would like to insert this table into a report in Power BI.

To do so, click the Report View icon on the left hand side:

Then click the Table icon under the Visualizations tab.

Then drag both Store and Sales to the Columns panel:

This will produce the following Table visual:

Suppose that we would like to increase the width of the Sum of Sales column in the table.

To do so, click the Format your visual tab under Visualizations, then click the dropdown arrow next to Column headers, then click the dropdown arrow next to Options, then turn of Auto-size width:

Next, hover over the right hand side of the Sum of Sales header in the table until an arrow icon appears, then drag the width of the column to the right.

This will increase the width of the column in the table:

If you would like the column width to be reset to the default width, simply toggle the Auto-size width feature back to On.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Apply Conditional Formatting to Bar Chart
Power BI: How to Add Average Line to Chart
Power BI: How to Create a Cumulative Line Chart

Leave a Reply

Your email address will not be published. Required fields are marked *