Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
<br> not working either
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
Thanks Qiuyun. This worked like a charm in a PowerPivot Report for me!
Hi @v-qiuyu-msft i am looking for line break in visual. for example
output
John Doe
JD@xyz.com
123-345-5677
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
At this point i am doing the same solution that you mentioned.
Have you tried this technique? http://markvsql.com/2015/03/advanced-column-splitting-in-power-query/
Treb Gatte | Business Solutions MVP | Blog | Twitter
Presuming \n doesn't do the trick? You've probably already tried this, but does char(10) or chr(10) do anything for you?
Both not working for me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
79 | |
66 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |