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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Balaji1414
Frequent Visitor

Fixed column width

Hi All, I have a matrix with four columns, when at the input side user changes the column name the width of the column is changing automatically, for this i have used "REPT" function to fix the column width. when the user edits the column name first time the width is not changing but when it repeats(column name editing multiple times) the column width is changing, can  anyone help with this? 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Balaji1414 

According to my test,

  1. When the "auto-size" of "column headers" is off, the column will keep its length, which won't change automatically.
  2. When the new data is added the first time, the column would fit its width automatically. 
  3. First set "word wrap" on, then set "auto-size" off, it would satisfy your scenario.

Ailsamsft_0-1630636214443.png

You can have a try .

 

Best Regards

Community Support Team _ Ailsa Tao

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

View solution in original post

5 REPLIES 5
iris__bi
Frequent Visitor

Thx! Just want to stop by and say thanks😀

ArieKanarie
Regular Visitor

Why isn't it possible to just set the column width as fixed with the number of caracters in the formatting pane? Would make my life a whole lot easier and would save me a lot of time using work arounds like column width measures (REPT..)

Anonymous
Not applicable

Hi @Balaji1414 

According to my test,

  1. When the "auto-size" of "column headers" is off, the column will keep its length, which won't change automatically.
  2. When the new data is added the first time, the column would fit its width automatically. 
  3. First set "word wrap" on, then set "auto-size" off, it would satisfy your scenario.

Ailsamsft_0-1630636214443.png

You can have a try .

 

Best Regards

Community Support Team _ Ailsa Tao

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

123abc
Community Champion
Community Champion

Good 👍.

 

This person is not correct.
The settings work for currently visible columns, for example Column years: 2022 and 2023.  If 2021 were added as a 3rd column via a selector, then the 3rd column has no defaults and is usually truncated.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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