Enable setting a fix width of each column in a matrix

[Thorunn_Arna_Om]

It is needed to be able to resize a column for all occurrences in a matrix. That is, not by dragging the size for each and every column value, but with setting a specific pt length in the visualization setup.

If the column values change, etc depending on a slicer selection, all resizing of columns stop working and the initial sizing of the column takes over. Therefore it needs to be possible to change the "initial size" of each column.

This is for example needed in cases where column titles are much wider that what the data values actually need - causing the column width to be set according to the title length(when it would be better to wrap the titles to two-three lines). Therefore the matrices look bad if it is not possible to size the columns according to plan.

[balachandra_sr2]

Can we have fixed column width for default Table and Matrix Visuals ? I see this feature available in "Financial Reporting Matrix by Profitbase".

[trdayma]

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.

[kevinh2]

agreed

[fbcideas_migusr]

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.

[fbcideas_migusr]

This bug is still there in November 2017 Release! I thought it was because I had Word-Wrap turned on ... but the re-sizing takes place even with the Word-Wrap off. Scenario is Matrix with Year on Columns. Once you make a new selection via a slicer all of the work you have done in getting the report to fit without the horizontal scrolling bar is undone. Very ... very frustrating. Please fix

[jeff_ho]

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.

[ssproat]

The columns still reset from custom widths for me as well. It definitely seems to be a bug, and continually resizing all of the columns is a huge waste of time.

[lauramma]

I tried to resize the column width for a matrix I created to fit all months into one page as well. But the resized width can never be the default size. Every time I reopen this report (either using Power BI Desktop or on Power BI cloud, the size of the column is still by default, even after I turn off "Auto-size column width" for the matrix.

[luizfornazza]

Last version installed right now, still having problems with this bug.

[buchisar]

problem still exists 😞