How can you detect the alt+enter in PowerBi

[remi]

Hello all,

Need some help in identifying the representation for alt+enter in Powerbi

Tried:  [ae] and Char(10) from excel, but they don't work.

Thank you for your help

[v-piga-msft]

Hi @remi，

You may have a try with UNCHAR(10).

Reference:

http://community.powerbi.com/t5/Desktop/How-to-get-text-in-new-line-using-data-cards/td-p/227630

http://community.powerbi.com/t5/Desktop/Have-new-line-character-in-Tooltip/td-p/348130

Best Regards，

Cherry

[remi]

Hello @v-piga-msft,

Thank you for getting back to me!

Tried your input on my exercise, but results are not those looked for. will look further.

If you have other suggestions please let me know. Thank you! 

[v-piga-msft]

Hi @remi,

By my test, the UNCHAR(10) has the same effect with alt+enter which is for newline.

Besides, what is your expected output? Could you describe your requirement in details, so that we can help further investigate on it?

Best Regards,

Cherry

[remi]

Hello @v-piga-msft,

Once again thank you for getting back to me.

What I'm trying to do is extract the text before UNICHAR(10), while this works great for the concatenation of text (very good example provided by you), it doesn't work for me.

Still looking into it.

Kind regards,