Forum Discussion

ahmadibrahimbus's avatar
ahmadibrahimbus
Icon for Resolver III rankResolver III
4 years ago
Solved

Matrix Fixed column size

Hello Community , this is my first quetion on power bi community. Happy to share knowledge and ask questions. As per my knowledge. power BI still has no option to fix the size of column matrix ,Howe...
  • ahmadibrahimbus's avatar
    ahmadibrahimbus
    4 years ago

    Hello Anonymous ,

    i would like thank you for your reply.

    I have solved using a trick.

    actually the header of matrix is a date so I have created a text column from this date and append whitespaces to it as below:

    WE Date = CONCATENATE(format([WE_Date], "dddd, mm dd,yyyy"),REPT(UNICHAR(127),35-len(format([WE_Date], "dddd, mm dd,yyyy"))))
    so using this formula I have fixed column size , hope this helps the rest of community members.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ahmadibrahimbus ,

As far as I known, the feature does not support not. You can vote here.

Matrix column header column widths resize even when "Auto-size" is off

Define "general" Matrix column width 

Enable setting a fix width of each column in a matrix 

 

I have also found a similar post, please refer to it to see if it helps you.

Matrix is auto-sizing Column width when turned off - Microsoft Power BI Community

  • 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. 

 

Best Regards

Community Support Team _ Polly

 

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