Matrix Fixed column size

[ahmadibrahimbus]

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 ,However;there is a workarround to use like a measure including a text with a certain number of characters to identify the column size then turn off-after the auto-size in column header and use the needed measure.

this works very well for the viewed data within matrix .As an instance if we have weeks data on rows level we have no problem with the viewed data.However when loading new weeks this trick isn't worked as requested.

anyone encounter this need?

Thank you for your support.

[ahmadibrahimbus · Accepted solution]

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]

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.