Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Enable setting a fix width of each column in a matrix

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.

Status: New
Comments
ovette_abejuela
New Member
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.
Dianapo
Microsoft Employee
Even though the Auto Size is turned off, the matrix (in preview) keeps changing sizes. This poses issues when trying to align with other charts and in addition, the size that the matrix changes to cuts off numbers (so definitely two bugs to think about - first, don't allow the matrix to change in size if auto size is off, and secondly if matrix does change size of auto size is on ensure that the numbers are not cut off).
dn_hernandez
New Member
The matix visual resizes columns even when the auto-size option is turned off for column headers. This appears to be a bug.
poojan1
New Member
Issue in the column width size in the matrix visual. Selected year 2017 in the date slicer. In the matrix, displaying the month and year values. Aligned the column width(12 Columns) to fit the page. But when the year 2016 Is selected, the column width which I resized is off. the width of the column is shrinked. It is not showing the same column width which I resized in 2017.
davidcadman
New Member
There are several ideas already about preserving column widths. The key point, for me, is that tables should be able to maintain the same dimensions if their content changes due to filtering.
guillaume_vissi
New Member
fix column size in tables and matrix In table and matrix having the possibility to manually fix the columns size with a defined size in pixel seems something easy to implement and would considerably ease our daily life when building tables in report, in particular when multiple tables must be homogeneous in size in the same report page
balachandra_sr2
New Member
Can we have fixed column width for default Table and Matrix Visuals ? I see this feature available in "Financial Reporting Matrix by Profitbase".
trdayma
New Member
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
New Member
agreed
fbcideas_migusr
New Member
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.