Adding line break to long text field (paragraph)

[Anonymous]

Hello All,

I have long text fields (Paragraph) in column. Want to add line break based on delimiter and show it in same field. Dont want to
split into multiple columns. Thanks in advance

[MFelix]

Hi @Anonymous ,

On the Query editor you can use the #(lf) ion this case I have added made text replace and the made the code like this:

= Table.ReplaceValue(Source,"*","#(lf)",Replacer.ReplaceText,{"Column1"})

[Anonymous]

I'm using Streaming Dataset here.  query editor option is not available

[MFelix · Accepted solution]

Hi @Anonymous ,

Then the option is to go for dax has @amitchandak  refered something similar to:

Calculated column

With Breaks = SUBSTITUTE( 'Table'[Column1], " * ", UNICHAR(10))

Measure

Measure With Breaks = SUBSTITUTE( SELECTEDVALUE('Table'[Column1]), " * ", UNICHAR(10))

Result below:

[Anonymous]

Hi,
Measure did work but getting alignment problem. Everything aligned to extreme right in each field. Tried formatting options but nothing working.

[MFelix]

Hi @Anonymous,

You need to text to be Justified? In Power BI text can only be align left, center and rigth there is no Justify option.

[Anonymous]

Text is aligned right, tried to moving it to left through formatting options but it  is not working.

[MFelix]

Is it a Matrix or a Table?

Have you tried and check the option of the specific column values that way you can individually change each of your columns to left or rigth alignment.

[MFelix]

Hi @Anonymous ,

Forgot to add the image of the property, has can see the measure is align center:

[amitchandak]

@Anonymous , We usually Try to add unichar(10) for a line break. But between text you may have substitute

https://docs.microsoft.com/en-us/dax/substitute-function-dax