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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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

Power BI Monthly Update - August 2025

Check out the August 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 Solution Authors