Skip to main content
Microsoft Idea

Power BI

Needs Votes

Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

Vote (604) Share
vetabz's profile image

vetabz on 13 Apr 2017 22:45:23

I so wish that you consider providing the ability to "Apply Width to all Data Columns" and maybe to Rows as well. This can be just a toggle (checkbox).

My current experience was to resize each of the 90-day worth of data and it was not very productive and I had to do this each time a new batch comes in.

Comments (44)
vetabz's profile image Profile Picture

Alex Rowntree on 05 Apr 2022 07:36:06

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

It's so annoying you can't do this! :(

vetabz's profile image Profile Picture

on 09 Dec 2021 21:20:17

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

It would be great if we can adjust the column width by indicating it to have columns with equal width. Also the option "Distribute columns" that is used in PowerPoint would be really helpful.

vetabz's profile image Profile Picture

on 09 Dec 2021 21:20:16

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

I would like to be able to expand and contract the width of columns

vetabz's profile image Profile Picture

on 09 Dec 2021 21:20:16

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

column width should not change once width is fixed and auto column width is off. Presently it is working if column are fixed for  matrix. If column changes based on slicer filter . It is not working

vetabz's profile image Profile Picture

Alex Batey on 08 Dec 2021 01:04:33

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

The inability of being able to set fixed column widths in a matrix and the column widths being retained when you change years in a slicer has meant customer will not use Power BI to meet their reporting requirements.

vetabz's profile image Profile Picture

Bernat Agulló on 23 Nov 2021 10:28:01

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

To whom it might interest, this is the workaround I came up with --
https://www.esbrina-ba.com/the-ultimate-hack-to-set-column-widths-in-a-matrix/

but I agree we should not need a hack for such a basic thing!

vetabz's profile image Profile Picture

Claire Allwood on 10 Sep 2021 00:40:23

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

Sometimes a pain? Always a pain. I am continually astonished at the simple things Power BI cannot do. For a software that is supposedly about visualisation, you cannot do anything useful with column widths, colours, pattern fills, styles. You can't even do combined graphs with multiple axes without downloading custom visualisations. This is a joke. You would think PBI would have more style/format customisation possibilities than Excel, not way less. At least you can VBA stuff native Excel won't do.

vetabz's profile image Profile Picture

Harika Karella on 02 Aug 2021 14:18:59

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

column width should not change once width is fixed and auto column width is off.

vetabz's profile image Profile Picture

Neil M on 14 Jul 2021 17:00:48

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

Absolute joke this is not an option...

vetabz's profile image Profile Picture

Joe Brazell on 21 Jun 2021 18:28:26

RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview

I agree with everyone else in this case. It is not an edge case. It is a basic function that exists in pretty much ALL Microsoft products except Power BI !!. We have it in Excel, Word/PowerPoint (Tables), Access, etc., etc.

DEV PLEASE PRIORITIZE!

Merged Idea (2)