Forum Discussion

ahmadibrahimbus's avatar
ahmadibrahimbus
Resolver III
3 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 ,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's avatar
    ahmadibrahimbus
    3 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.

2 Replies