Skip to main content
Microsoft Idea

Power BI

Needs Votes

Set Column Widths

Vote (457) Share
Billy's profile image

Billy on 01 Jun 2018 22:32:01

Allow user to set column widths en masse. Ideally for each variable. For instance, I have sales and market share for each of ten years. If I am not good with the auto set width, rather than having to manually modify the width for each year, I should be able to either enter a width for the field OR manually change one and have the other years follow suit. Either would be helpful, rather than visually setting the widths and hoping I have them equal.

Comments (32)
Billy's profile image Profile Picture

Power BI User on 06 Jul 2020 00:12:38

RE: Set Column Widths

This should be a basic Power BI feature, Excel implemented this more than 20 years ago.

Billy's profile image Profile Picture

Neil on 06 Jul 2020 00:11:47

RE: Set Column Widths

Yes Please...

Billy's profile image Profile Picture

Veronika on 06 Jul 2020 00:03:57

RE: Set Column Widths

Please, we would also apprecitate this feature. Thank you

Billy's profile image Profile Picture

Eli on 05 Jul 2020 23:57:01

RE: Set Column Widths

It should be useful to be able to set the column width based on a numerical series

Billy's profile image Profile Picture

Agustin on 05 Jul 2020 23:48:28

RE: Set Column Widths

need this!

Billy's profile image Profile Picture

john on 05 Jul 2020 23:36:13

RE: Set Column Widths

I would like to be able to set the column width to zero if all values in the column were null

Billy's profile image Profile Picture

ThomasDay on 05 Jul 2020 23:26:59

RE: Set Column Widths

There are many ideas pointing to issues with how powerbi matrices and tables handle column widths. It is honestly inconceivable that these visuals cannot have widths set to a value for one, many, or all columns... There is not another spreadsheet (perhaps ever) that didn't allow that. (Visicalc, Lotus 123, Excel, Numbers, Google Sheets, Tableau, to name a few) It's such an obvious need that it doesn't get much play here and the width issues just continue to be buried and pushed aside by sexy features.

Sure would like it to be fixed. I have 5,000+ potential column headings depending upon filters (not every table is months of a year) and what can I do with that? Set each one on every matrix that uses that column source? I'm sure I'm not alone...we're the silent majority I guess.

Billy's profile image Profile Picture

Calvin Francart on 05 Jul 2020 23:26:21

RE: Set Column Widths

This definitely needs to be added for matrix visualizations.

Billy's profile image Profile Picture

BPWest on 05 Jul 2020 23:21:45

RE: Set Column Widths

This is a must have. I think the majority of people using this want to spend their time on data and analytics, not manually adjusting column widths every time we add a new value to a matrix.
Even when manually adjusting there is no way to ensure every column is the same width!!

Billy's profile image Profile Picture

Lutz on 05 Jul 2020 23:19:21

RE: Set Column Widths

table column width seems to be recalculated if the data width changes (larger currency values, longer text). Would be nice to be able to freeze column width.

Merged Idea (3)