Forum Discussion

FawadRehman's avatar
FawadRehman
Icon for Helper I rankHelper I
10 years ago

link 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'...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

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's avatar
satbirminhas
Icon for Advocate II rankAdvocate II
8 years ago

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