Forum Discussion
Adjusted column width changes on column selection
Hi jrobinson,
I can reproduce your issue when I only have Rows and Values in the matrix preview. However, when the matrix preview contains Rows, Columns and Values, everything works well after manually changing column width.
Based on WillT’s reply in this similar thread, if the matrix preview only contains Rows and Values, it doesn’t work as expected when we manually set column width, this is a known issue and it will be resolved in a future update.
Thanks,
Lydia Zhang
With the July general release of the "new Matrix", the column widths do not stick even with Rows, columns, and Values. Where should I report this?
- ThomasDay9 years agoImpactful Individual
With the July Release, are New Matrix column widths staying put for anyone else who has dragged the column space separators to set col widths?
- Dog9 years agoResponsive Resident
I think that these are usually raised as issues within the ideas area.
http://community.powerbi.com/t5/Issues/Matrix-Column-Auto-size/idi-p/140771
this one seems to relate to a similar issue.
I am also having the issue you are referring to but this only seems to be a problem when I have columns and not just values selected
- ThomasDay9 years agoImpactful Individual
Thanks, I've put it over there. Still no response from anyone to acknowledge the issue or help me/us understand that it's going to be fixed.
- Dog9 years agoResponsive Resident
Hi ThomasDay
I've been looking into this a bit more and the issue of the columns not retaining their sizes seems to only occur when you are passing a value into the column field and not just values.
I've been able to work around mine (although not ideal as it's a little slower) but it's a workaround none the less.
my matrix was purely to break out values into each month of the year, so I have had to write measure for each month.
and I've passed all the months in as just values. with auto size switched off I can now resize and these are retained.
the two comprises here for me have been 1, I have had to write my own total measure and 2. because of this new total measure my values aren't in bold but with column formatting I've been able to set the back ground colours etc... so it doesn't look too bad.
Dog!