Power BI
Needs VotesAbility to "Apply Width to All Columns" of Table, Matrix & Matrix Preview
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 (16)
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.
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
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.
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.
RE: Ability to "Apply Width to All Columns" of Table, Matrix & Matrix Preview
agreed
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.