Forum Discussion

FawadRehman's avatar
FawadRehman
Helper 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
FawadRehman's avatar
FawadRehman
Helper I
10 years ago

<br> not working either

v-qiuyu-msft's avatar
v-qiuyu-msft
Community 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

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      10 years ago

      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's avatar
        FawadRehman
        Helper I
        10 years ago

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

  • satbirminhas's avatar
    satbirminhas
    Advocate II
    8 years ago

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