Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Jim123456789jim
Frequent Visitor

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.

1 ACCEPTED SOLUTION
CrisYan
Resolver III
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.

 

View solution in original post

4 REPLIES 4
Berenice
Frequent Visitor

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

benik9
New Member

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
Microsoft Employee
Microsoft Employee

Hi @Jim123456789jim,

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

Thanks,
Angelia

CrisYan
Resolver III
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.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.