Right Pad Text record values with spaces

[wfarm]

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?

Thanks

[v-cgao-msft · Accepted solution]

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!

[wfarm]

Thanks Greg.

My situation is that I want to build a matrix with this field becoming the column. The number of values will change from monmth-to month. I can set the column width now and turn off "Auto-fit" on the column settings but then next month I may get a value in a record that is longer and then it stretched out and doesn;t automatically wrap. I was hoping that if I set a maximum length and then kept auto-wrap on, the new values, along woth the previously seen values, would all be the same width.
Am I missing something?
Is there another way to deal with this so that my column widths remain constant?

THanks!

[Greg_Deckler]

@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.