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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Employee
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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors