Forum Discussion

mork's avatar
mork
Helper V
10 years ago

New line Characters

Hello,  I use an excel file to import some text notes into Power BI for our departments. The notes are around two paragraphs and the show fine on excel. When importing them to Power BI they appear a...
Need Help
bullius's avatar
bullius
Helper V
9 years ago

Hi Vicky_Song,

 

I don't think this issue has been resolved. If it has, could you direct me to the solution?

 

I need to display an address like this:

 

Line 1

Line 2

City

Postcode

 

Instead of this:

 

Line 1, Line 2, City, Postcode

 

Thanks!

dhawal16's avatar
dhawal16
Advocate I
8 years ago

Hi,

 

I know you asked this question on 2016, though if you are still looking for an answer. It should work from below

This will work considering you have seperate column for each. If that is not the case just replace (,) with #(cr)#(lf)

 

= Table.CombineColumns(Table.TransformColumnTypes(#"Source", {{"Line1", type text}, {"Line2", type text}, {"City", type text}, {"Postal Code", type text}},Combiner.CombineTextByDelimiter("#(cr)#(lf)", QuoteStyle.None),"Address")

 

 

Mark this as a Solution if this work.

 

Thanks,

Dhawal