Adding extra spaces to end of value

[m_alireza]

Hi All, 

I am trying to add extra spaces and a dot to the end of my values in my column. It seems to work in Power Query but when I add it onto a table, Power BI is not honouring it...

For example, lets say I have a table with a column called Fruit. I want the values in there to have around 20 spaces (doesnt have to be exactly 20, just a good amount of spaces) after the text followed by a ".". See sample table/expected output below:

Sample table

Fruit	Expected Output
Apple	Apple               .
Orange	Orange             .
Kiwi	Kiwi                  .

I tried using this formula in Power Query and it works when the editor is open:

= Table.AddColumn(#"Changed Type", "Fruit_Padded", each Text.PadEnd([Fruit],20) & ".")


but when i try to put it in a table, it doesnt work anymore. the "." is placed right after the word (although when i hover over it, I can see the spaces)


Is there a way to fix this? 

Appreciate your help. 

[m_alireza]

@Greg_Deckler , thank you!

[Greg_Deckler · Accepted solution]

@m_alireza Use this:

= Table.AddColumn(#"Changed Type", "Fruit Padded", each Text.PadEnd([Fruit],20,Character.FromNumber(160)) & ".")