cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Microsoft

@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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors