Forum Discussion

wfarm's avatar
wfarm
Frequent Visitor
4 years ago
Solved

Right Pad Text record values with spaces

I have a text field that I'm using for matrix columns. I'd like to pad each value to a maximum length of 25. I am not finding a function to do this.   Is there a way to right pad a text field?  ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi wfarm ，

     

    Maybe a measure can be used to solve this.

    I created a matrix with a simple.

    Matrix at the beginning.

    The longest number here is 999999999.So I created a measure to represent the width of the column I want. Put it into the matrix.

     

    widths = 123456789

     

    Then turn of the Auto-size width.

    Replace widths with values.

    Attach the pbix file for reference.

    Hope it helps.

     

    Best Regards,

    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

wfarm Perhaps a Custom Format String. Otherwise, you could do this:

Measure = 

  VAR __Text = MAX('Table'[Column])

  VAR __Len = LEN(__Text)

  VAR __Rept = 25 - __Len

RETURN

  REPT(" ",__Rept) & __Text

 

Or perhaps I am not understanding.