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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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

3 REPLIES 3
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.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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