Forum Discussion
Helper Ilink break character in calculated column
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
123-345-5677
Thanks
10 Replies
- jayeckles
Advocate III
Presuming \n doesn't do the trick? You've probably already tried this, but does char(10) or chr(10) do anything for you?
FawadRehmanBoth not working for me.
- Greg_Deckler
Community Champion
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
- trebgatte
Most Valuable Professional
Have you tried this technique? http://markvsql.com/2015/03/advanced-column-splitting-in-power-query/
Treb Gatte | Business Solutions MVP | Blog | Twitter
- FawadRehman
<br> not working either
v-qiuyu-msftCommunity Support
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
