link break character in calculated column

[FawadRehman]

Here is my lookup column code

Full Contact = LOOKUPVALUE(' Contacts'[Manager Name],' Contacts'[Id],'Customer Contact'[ ContactId])
& "i want line break character here " & LOOKUPVALUE(' Contacts'[Email],' Contacts'[Id],'Customer Contact'[ ContactId])
& "i want line break character  here " & LOOKUPVALUE(' Contacts'[Telephone],' Contacts'[Id],'Customer Contact'[ ContactId])

output

John Doe

JD@xyz.com

123-345-5677

Thanks

[Greg_Deckler]

See the thread here and see if any of the suggestions fix it. There are 2 pages and they note that <br> should work.

http://community.powerbi.com/t5/Desktop/New-line-Characters/td-p/37634/highlight/true

[FawadRehman]

<br> not working either

[v-qiuyu-msft]

Hi @FawadRehman,

Based on my test, we can press <SHIFT>-<ENTER> buttons to add a line break in a DAX expression. Please note the line break will not display when we present the data in visuals, but it actually exists. When the cursor hovers on the value, the tooltip will display value with a line break. See:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[satbirminhas]

Thanks Qiuyun. This worked like a charm in a PowerPivot Report for me!

[FawadRehman]

Hi @v-qiuyu-msft i am looking for line break in visual. for example 

output

John Doe

JD@xyz.com

123-345-5677

[v-qiuyu-msft]

Hi @FawadRehman,

I'm afraid it's not supported to display one value in many lines in a visual currently. You need to split the value to many records then display them in a visual on many rows.

Best Regards,
Qiuyun Yu

[FawadRehman]

At this point i am doing the same solution that you mentioned. 

[trebgatte]

Have you tried this technique? http://markvsql.com/2015/03/advanced-column-splitting-in-power-query/ 

Treb Gatte | Business Solutions MVP | Blog | Twitter

[jayeckles]

Presuming \n doesn't do the trick?  You've probably already tried this, but does char(10) or chr(10) do anything for you?

[FawadRehman]

Both not working for me.