Forum Discussion
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...
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.
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.