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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
mgw71
New Member

Matrix Table resizing columns with Autosize column turned off !

Turned autosize width off in column headers, manually adjusted column widths,  matrix table is still autosizing column widths when slicer selection changes. Happens even with word wraps turned off is this a known bug if so very frustrating that it can not hang on to basic formatting! 

5 REPLIES 5
catharinadavies
New Member

Hi, I understand how frustrating this is, but I am using a very simple work around:   

 

Where you have the Values (ie columns) rename the column Name:   -    'Column Name'    (spaces)   -

This makes the matrix think the column, using auto spacing, needs to be wider, to account for the larger column title. Turn the text wrap off for the columns.

 

I love simple solutions. 

v-kpoloju-msft
Community Support
Community Support

Hi @mgw71,

Thank you for reaching out to the Microsoft fabric community forum.  Also, thanks to @grazitti_sapna@Ritaf1983,  for those valuable insights on this thread. Here I mentioned workaround that might be resolve the issue. Please have a look into it.

This is a known limitation in the Power BI Matrix visual. While the “Auto-size column width” setting disables automatic resizing, the Matrix visual can still recalculate and override your manual column widths when slicer or filter interactions cause:

  • New or removed columns (e.g., categories appearing/disappearing)
  • Changes in column header text length
  • Structural re-renders due to dynamic column values

This is not currently classified as a bug, but rather a by-design behaviour of the visual rendering engine.

The current workaround is: In the Matrix visual: Set Auto-size column width = Off under Column headers, Values, and Subtotals. Set Word wrap = Off.

After applying the above, manually resize your columns again. Avoid dynamic slicers that change the column layout. If possible:

  • Use fixed columns by reshaping the data model
  • Move filters from columns to rows or the filters pane

If the issue persists, try building a new matrix visual with these settings applied fresh.

Since this is a UI behaviour and not a technical error, we recommend to raise a ideas forum through the below mentioned link: Fabric Ideas - Microsoft Fabric Community

If already raised a ideas forum on this type of threads please upvoting. The Ideas portal is actively monitored by the Power BI product team, and feedback here helps shape future enhancements.

Let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

Hi @mgw71,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that is great to hear. And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you!

grazitti_sapna
Super User
Super User

Hi @mgw71 

 

Yes, this is a known and long-standing issue in Power BI.

Even when "Auto-size column width" is turned off in a Matrix or Table visual, column widths can still reset when:

  • A slicer selection causes some values to disappear or new values to appear.
  • There are measure changes or dynamic columns affecting the layout.
  • Field formatting or visibility changes based on filters or bookmarks.


Workaround:
Switch to Table visual instead of Matrix
If you're not using row/column groups heavily, consider using a Table instead of a Matrix, which tends to behave better with manual formatting.


 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Ritaf1983
Super User
Super User

Hi @mgw71 
This is a known issue.
Try the workaround in the linked video:
https://www.youtube.com/watch?v=twiwgEXy87g

And vote for the ideas:
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Ability-to-Adjust-column-width-in-table-and-m...

https://community.fabric.microsoft.com/t5/Fabric-Ideas/Fixed-Column-Width-for-Columns-in-PBI/idi-p/4...

https://community.fabric.microsoft.com/t5/Fabric-Ideas/Retain-Column-Width-on-Table-Matrix/idi-p/451...

i voted and 

I’ll share it in a few colleague groups that I manage so they can vote as well.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.