Forum Discussion
Matrix is auto-sizing Column width when turned off
I see previous threads on the topic. I am unclear if this is a Bug or limitation to the "Auto-size column width - OFF" When the report refreshes the new months are auto-sized. Please fix this, PBI is making the reporting group look bad; such a little thing makes a big impact. Ha
5 Replies
Fro88er You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Thanks for your suggestion, I submitted a support ticket; they were super helpful. The result was to manually adjust each column. This solution is unrealistic, because I would have to update the report weekly, additionally adjusting the columns width manually did not "stick" for the new column after refresh.
Hi Fro88er ,
If you ever narrowed the three column in headers manually, then turn on the option "Auto-size column width", it will display the auto size column width, and then if you turn off this option, it won't reverse to its original narrowed column width. If you need desired column width, you may try to adjust the width manually.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I've tried turning the auto-size option on and then removing it. The column width still snaps back to the auto-size. I have other Matrix visualisations on the same page, with the same configuration/appearance and none are doing this. There must be another option or a bug that is causing this. The only solution for me was to delete the matrix and re-create it.
Hi guys,
Just wondering if this has been resolved? I am using July 2025 edition.
- I add a date (eg year 2024, 2025, 2026) to a slicer
- I add the same field as a Column to a matrix visualisation (the slicer then selects which year is used as the column in the matrix)
- I disable Auto-size width for the column (Visual -> Column headers -> Options -> Auto-size (off)).
- I manually set the column with for the columns- If I select a new month using the slicer, the columns then resize.
Kind regards,
Ben.
