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
ThomasDay
Impactful Individual
Impactful Individual

Carriage Return in Text String

Hello fellow Dax'ers,

 

I read an interesting blog post by Chris Webb on dynamic chart titles.  Nicely done.   It uses a card visual to display a concatenated title from slicer table[variables].  My darn "card" first off, doesn't word wrap...grrr...but beyond that I'd like to insert a carriage return in the text string and then do some formatting--add a tab maybe?.

 

So how the heck do I put in a carriage return into the string?  How about Tab? (OK, that doesn't really matter...I'll put spaces in for the "tab" but if there were one.

 

Thanks,

Tom

5 REPLIES 5
MattSwan
Frequent Visitor

alt+enter to add a carriage return, then type in a space in the line between text i.e.

 

Test = "Before carriage return
 
After carriage return"
Eric_Zhang
Microsoft Employee
Microsoft Employee

@ThomasDay

 

If you're talking about display a carriage return in a Card visual, there seems no way.

 

You can put in a carriage return by "alt+enter", but it won't display as a new line in visuals. when hover your mouse on the card, you can see the value with carriage returns. This behavior looks by design.

Capture.PNG

Thank you very much.  Would have loved to either have a card actually "word wrap" which is a selection that doesn't seem to make any difference, or be able to put in carriage returns manually.

 

I appreciate your help!

Tom

Would concatenating UNICODE(10) to the string achieve what you're after?

UNICHAR(10) does the job

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.