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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.