comma under comma in table

[fsfs]

hey guys

how do I format data so it would appear in the table with commas below each other?

I have

1.05

12.035

-2.4

-20.411

and I would like to get

  1.05

 12.035

 -2.4

-20.411

[fsfs · Accepted solution]

Answer - the quickest and most straightforward way to achieve this is to use right alignment, while having data cropped to a certain decimal places 🙂

[fsfs]

with zeros I could do this with FORMAT( column, "000.0")

I could do this with several IFs and CONCATENATE (with whitespaces, + signs etc) but I though there might be a FORMAT() option

[Tanushree_Kapse]

Hi @fsfs ,

Go to your Power Query Window , then click on Add Custom Column and then put this syntax there

Text.PadStart(Text.From([measure_name]),2,”0″)
It would add zeroes at the start...may be that can get you what you want.

Kudos are always appreciated!