Table of Contents
Yes, it is possible to change the column width in a table using Power BI. This can be done by selecting the table and then adjusting the column width using the column headers or by using the formatting options in the “Format” tab. This allows for customization of the table layout and presentation of data in a visually appealing and organized manner.
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: