Skip to main content

Power BI

Needs Votes

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

Vote (621) 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 (43)
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.

vetabz's profile image Profile Picture

Kevin Hoffman on 05 Jul 2020 22:59:40

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

agreed

vetabz's profile image Profile Picture

Tom Day on 05 Jul 2020 22:55:33

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

The New Matrix takes away the previously available ability to set all Matrix columns to a standard width. Now, you can set each column heading to a width that will track that column's location...but with 5000 different potential columns...clearly that's not a workable solution.

The idea of having 5000 potential columns is NOT an edge case...it's an important use case of the Matrix visual. (Think distributors with many customers to display side by side...or products side by side...etc. The list goes on and on). So clearly removing the ability to set widths was ill-considered imo. Please restore this capability.

Merged Idea (2)