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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors