Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (605) 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 (42)
vetabz's profile image Profile Picture

Adrian on 06 Jul 2020 00:10:56

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

Yes please! It would be very helpful!

vetabz's profile image Profile Picture

Andrew on 06 Jul 2020 00:10:30

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

Please consider adding this feature! Something akin to even how you can resize all bars in a bar chart evenly for matrices would be incredibly helpful!

vetabz's profile image Profile Picture

Chenna Kesava Reddy Manyam on 06 Jul 2020 00:08:07

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

I do want increase height and width of my column headers in matrix table

vetabz's profile image Profile Picture

Rasmus Kaas on 06 Jul 2020 00:06:27

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

it's 2020, and as much as I love Power BI, I almost cannot believe that this "feature" is not implemented yet :(. That, and +/- option for matrix columns.

vetabz's profile image Profile Picture

Adam Szitas on 05 Jul 2020 23:56:22

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

Resizing and autofiting matrix is not something one should google and even less something that isnt implemented

vetabz's profile image Profile Picture

Richard Power BI User on 05 Jul 2020 23:54:38

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

Agreed. This is not exactly an edge case in BI.

vetabz's profile image Profile Picture

Power BI User on 05 Jul 2020 23:30:00

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

Please add this ability as it is annoying to have to resize every column and try to each to be the same size.

vetabz's profile image Profile Picture

Steve on 05 Jul 2020 23:22:37

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

Even the option to "Make all column widths equal" would be an improvement

vetabz's profile image Profile Picture

JHo on 05 Jul 2020 23:05:30

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

I almost feel like anything I can do with a pivot table in Excel, I should be able to do with a matrix in Power BI, including resizing multiple columns.

vetabz's profile image Profile Picture

ThomasDay on 05 Jul 2020 23:02:40

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

I've posted on this issue before and I don't think it's registering with the dev team. This is a very big deal for the many types of models that pull column headers of all sizes from a long list...like product names/sku's, or a distributor customer's names, or in my case any from over 10,000 healthcare providers for matrix display of side-by-side performance.

Matrices offer such power in being able to vary columns based on selections/slicers but when we are unable (as in no-longer able--it used to be possible in the old matrix) to set a column width, these displays are hugely unattractive and unmanageable.

What can possibly be gained by eliminating this straightforward ability?

As it now stands, every possible instance of a column header needs to have it's column set. So I'm sure the issue is clear...that is simply not workable. There are so many of us who are trying to work around a really difficult shortcoming of a feature that was deprecated with the new matrix.

Merged Idea (2)