Search code examples
powerbipowerqueryline-breakspowerbi-desktopm

Is there a way to add line breaks in a string of text in M (Power BI)?

I concatenated four columns using this code (to prevent null values to be linked together) in Power Query (Power BI Desktop):

= Text.Combine(List.Select(
{ [Col1], [Col2], [Col3], [Col4]    
}, each _<> "" and _ <> null),"; "))

I was wondering if there is a way to insert a line break instead of the "; " delimiter; that would make my visuals look neater!

Thanks in advance!

Solution

  • you can use Lines.ToText (https://learn.microsoft.com/en-us/powerquery-m/lines-totext) without the optional lineSeparator.