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!

Anonymous's avatar
Anonymous
Not applicable
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!