Forum Discussion

Jim123456789jim's avatar
Jim123456789jim
Frequent Visitor
8 years ago
Solved

Line Break up in DAX

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.

  • 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.

     

4 Replies

  • CrisYan's avatar
    CrisYan
    Resolver III

    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.

     

  • 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],
  • Berenice's avatar
    Berenice
    Frequent Visitor

    "Text Wrap" in Callout Value if you're using a card