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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
svella
Regular Visitor

Carriage Returns / concatenated text

Hi,

 

Does anyone know if we can add a carrage return and have it function in a text block in the visualization.

 

The goal

------------

Field_A & " - " & Field_B & Carrage Return & Field_C

 

Outcome

------------

Dog - Cat

Horse

 

Can't seem to find a thread where someone was successfull.

 

Cheers

9 REPLIES 9
Gianluca88
Resolver I
Resolver I

Gianluca88_0-1665150204652.png

Hi @svella , if you want the effect reported in the image below, you have to select "wrap text": ON in the visual card properties.

 

I used the DAX formula

 

CONCATENATE(CONCATENATE("Selezionare le celle di interesse dal selettore a sinistra digitando alcuni caratteri (consigliati almeno 4 caratteri)",UNICHAR(10)),"Puoi utilizzare i simboli jolly '?' e '*' nella barra di ricerca.")


Thanks,

g

MelindaLadd
New Member

Use #(lf) inside your quotations

 Field_A & "#(lf)" & Field_B

 

Just reverse what you would do if you were splitting the column. 

 

SanSan83
Regular Visitor

I have the same problem, I would like to add a "Carriage return" to concatenated text. Could you please let me know if/when you find a solution to the problem?

 

Many thanks,

add UNICHAR(10) into your text string... seems to work.   can't find the thread i found that in!

UNICHAR(10) works but doesn't appear to do anything for the visual and also causes line breaks in a csv export. 

Check that. If you turn on "Word wrap" in Values, it'll wrap those values in the table view according the break code. Nice.

v-sihou-msft
Microsoft Employee
Microsoft Employee

@svella

 

In DAX, , you just need to use "Alt + Enter" to type "Carriage Return". However, "Carriage Return" can't be displayed in visual. It always appear in a line. You can see the actual field when you hover on the data field.

 

Column = Table2[NAME]&
"
"
&Table2[id]

7.PNG

 

 

Regards,

Hi Simon,

 

Yes I use that technique for the code lines but I am looking for it to show visually.  I assume at this point their isnt a way to

add one to appear in the visuals ?

 

thanks

@svella

 

Currently, it's not supported to display the Carriage Returns within cells in visual.

 

Regards,

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.