Skip to main content

Power BI

Needs Votes

Set Column Widths

Vote (475) 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 (34)
Billy's profile image Profile Picture

on 05 Jan 2022 00:23:41

RE: Set Column Widths

Right now, I'm finding that I'm spending A LOT of time fiddling with column widths for all my matrices when in the end I'm attempting to create the same effect every time:

An even distribution of the Values Columns to fill the visualization's width.

Matrix Values Columns should do this by default and should be responsive to changes in the visualization width or the Row Header Column width.

Then, you can provide a setting called something like " Matrix Column Width Control" that is set to either "Automatic (default)" or "Manual".

Thank you!

Billy's profile image Profile Picture

on 05 Jan 2022 00:23:40

RE: Set Column Widths

There appears to be a lot of ideas regarding setting matrix column widths. Adding up all the votes could prioritize this higher. Controllable column widths for matrix visuals are requested repeatedly over several years.

Billy's profile image Profile Picture

on 05 Jan 2022 00:04:58

RE: Set Column Widths

Width of a column set up in centimeter (Matrix)

On the matrix visual, it would be nice if we could define the width of a column in centimeter.
Each column would have the width specified and if the « word wrap boutton » activated, it would display as many line as needed.

Billy's profile image Profile Picture

Thuy Duong Le on 16 Dec 2021 23:57:45

RE: Set Column Widths

Add duplicates you find here: https://forms.office.com/pages/responsepage.aspx?id=v4j5cvGGr0GRqy180BHbR8cfSq6VQ9NGsvE7PDcDatFUOEY5NVNGNVhDRDJEVkRBRUdES1pKMk8xUS4u

I'm using this one as the original post since it's pretty old: https://ideas.powerbi.com/ideas/idea/?ideaid=0f108839-0629-4b0b-8443-f2990ffb5700

Billy's profile image Profile Picture

SCOTT JEFFRIES on 14 Jan 2021 22:50:07

RE: Set Column Widths

Trying to display survey results that include open-ended text responses. The columns are many times wider than the screen and in order to resize them, I have to drag them one screen width at a time. This is such a pain and so unnecessary.

Billy's profile image Profile Picture

Guilherme Higashi on 29 Jul 2020 16:05:05

RE: Set Column Widths

Adjusting column width with numerical values would be so much way easier than using the classic "ruler + magnifying lens" combo

Billy's profile image Profile Picture

Dave Marchand on 14 Jul 2020 18:12:40

RE: Set Column Widths

I totally agree!! With no reference to the actual width of the columns, it is a big time wasting activity to try and get tight and uniform columns.

Billy's profile image Profile Picture

Adrie van Eekelen on 06 Jul 2020 00:18:17

RE: Set Column Widths

It would be very useful in table and matrix visuals. Thank you.

Billy's profile image Profile Picture

Power BI User on 06 Jul 2020 00:17:46

RE: Set Column Widths

This would be a huge improvement to speed up formatting tables/matrices with a large number of columns.

Billy's profile image Profile Picture

Pooja Bumb on 06 Jul 2020 00:16:55

RE: Set Column Widths

this is a really important and a basic feature. Please add it soon

Merged Idea (3)