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!

wfarm's avatar
wfarm
Frequent Visitor
4 years ago

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!