Forum Discussion
Display text in table/matrix without removing whitespace
Hi Anonymous ,
The problem here is that the spaces get trimmed in this case you need to replace the space by the empty character.
You can copy paste from this link:
Has you can see below I have two rows one with the spaces and the empty character:
In this I have made a replace values:
Table.ReplaceValue(#"Added= Table.ReplaceValue(#"Added Custom"," ","<u+200f><u+200f><u+200e> <u+200e>",Replacer.ReplaceText,{"Custom"})nbsp;e.ReplaceValue(#"Added
nbsp;e.ReplaceValue(#"AddedThe text seems the same thing but is from the white space.
Hi Anonymous ,
The problem here is that the spaces get trimmed in this case you need to replace the space by the empty character.
You can copy paste from this link:
Has you can see below I have two rows one with the spaces and the empty character:
In this I have made a replace values:
= Table.ReplaceValue(#"Added Custom"," ","<u+200f><u+200f><u+200e> <u+200e>",Replacer.ReplaceText,{"Custom"})nbsp;e.ReplaceValue(#"Added
nbsp;e.ReplaceValue(#"AddedThe text seems the same thing but is from the white space.
I accomplished this in a similar way to MFelix. Power BI will trim the leading spaces on a new line, but it won't trim "non breaking spaces." And Power Query has an easy way to turn normal spaces into non-breaking spaces.
For my purposes, I made the indents in excel using 3 or 4 spaces. I had Power Query change every double space into two non-breaking spaces.
You can actually accomplish this from the GUI.