New line Characters

I'm told this is available in the July 2017 release...

The Power BI Desktop July release has word wrap support e.g. Measure = "This is the first line" & UNICHAR(10) & "This is the second line".  Make sure you turn on word wrap for the grid/title for the visualization.  https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/

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

Has anyone had any luck implementing this in the Card Visual ???

mork, please have a check on arify's solution to see whether it works. If you still need further help, please post back.

Vicky_Song Unfrtunately arify's solution is for splitting columns and not for line feed.

I think I've reproduced the issue, which turned out to be not an issue. Have you tried clicking those cells? Sometimes Excel shows multiple lines as one line, but when you click to that cell on the formula bar it shows it as multiple lines.

arify / Vicky_Song -

I am not sure this thread is closed or the issue has been resolved....

But, I can reproduce the issue - that New Line or formatted text values ( fields created with special charactures #(cr)#(lf) or #(tab))

show up as formatted values in Power BI - Power Query, but the formatting is lost after the query is applied.

I am a newbe, so I may be wrong, but I have the same desired outcome as to want to display in a Text Visual a formatted string

For example:

John P. Jones
1121 S Andrews St
Faraway, NM, 09876
(123) 456-7890

I can create the field in Query Editor, but the formatting #(cr)#(lf) are lost when moving to the data view or in visualizations.

Is there a fix for this, or am I missing something in my approach.

Thanks for any guidance!!!

Hi Johnnyg, when I checked it, at first it looked like one line, but the new line character is actually still there. What visualization are you using? Can you try to expand the size of the row vertically?

I have used a couple with the same results: LongTextViewer,  Table (standard with PowerBI).

The field value in Query Editor displays:

Edward

Jones

The Data Views displays:

Edward Jones

The Visuals (both) displays:

Edward Jones        (independent of the column/field width.

Can you please send a frown with that, and make sure you include the information in your last message (and maybe a link to this thread)?

Thanks

Done...Thanks!

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!

Sean "Any luck" yes: bad luck :smileylol:

It only seems to work with the matrix and table visuals.

Sean - did you have to do something special to make Unichar work? I keep getting stuck with an invalid syntax error - but I can't see what I'm doing wrong. 

Sean

Thanks! I have been looking for this. This worked for me.