Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview
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.
Adam Szitas commented
Resizing and autofiting matrix is not something one should google and even less something that isnt implemented
Agreed. This is not exactly an edge case in BI.
Please add this ability as it is annoying to have to resize every column and try to each to be the same size.
Even the option to "Make all column widths equal" would be an improvement
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.
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.
Kevin Hoffman commented
Tom Day commented
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.