Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a matrix (using the new matrix preview which hugely condenses the row hierarchy) in Power BI. I am able to resize the columns and have word wrap on, but when I clikck on any of the other columns (i.e. to sort by value) all of the columns go back to the full width required to fit in the header.
Does anybody know how to get the columns to remain at the size I set them too? I've tried turning Auto-size off but this made no difference.
Thanks in advance
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?
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
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.
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!
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?
Hi @jrobinson
this looks like a defect in the preview visual, on the original matrix, switching off resize was all if took.
not sure who you would notify... I'm sure someone else will comment.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |