Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Shorten or lenghten column

Hi,   I want to determine the width of matrix-columns, which are added/ deleted by the user. The "0000000"- solution does not work as some names are longer, others are shorter.   I am trying to s...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    So a custom column like this?

     

    Text.Replace(Text.Start([Column], 15), "X", Character.FromNumber(173))

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you!

 

Yes...but: Don't I have to do the transformation in Dax - otherwise the "empty spaces" are deleted?

 

My goal is to have a column with names having a length of 15 chars, so that I can trick a matrix visual in having similar-length columns. The "000000"-trick is not possible since a user adds columns to compare companies.

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

You can do it in DAX with the same logic.

SUBSTITUTE ( LEFT ( Table1[Column], 15 ), "X", UNICHAR ( 173 ) )

I'm not sure what the "000000"-trick is.