Line Break up in DAX

[Jim123456789jim]

Hi All,

 How to write line break function in concate funcation. I tried with <br /> but it was not working

Can you please help on this.

[benik9]

In the concatenate code, if you insert a "shift + enter" after the comma, it gives me a line break, without breaking the code.

                'Query1'[LetterCode],

                ",{insert SHIFT-ENTER here}",

                'Query1'[LetterCode],

[v-huizhn-msft]

Hi @Jim123456789jim,

After research, please refer to the solution here. Please respond me if you have other issue.

Thanks,
Angelia

[CrisYan · Accepted solution]

Try using UNICHAR(10). For example: Column = "Line 1"& UNICHAR(10) & "Line 2".

And make sure you have the "Word Wrap" option activate on your Card/Table/Matrix/etc.