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! Request now

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.
rios_carlos
New Member
It's important that it can be modified and can be static.
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.
MJamesP
Regular Visitor
In Matrix and Table Visuals have the column width be an option that can be resized by typing in a column width value versus mousing it. This would allow the Developer to be more precise in displaying the visual. Also easier. Mimics Excel functionality.
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
mhutchinson25
New Member
NULL
mhutchinson25
New Member
It'd be useful if you could amend the column width property of a Matrix visual (ideally per field) via the format pane rather than manually dragging on the visual.