Carriage Returns / concatenated text

[svella]

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

[Gianluca88]

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]

Use #(lf) inside your quotations

 Field_A & "#(lf)" & Field_B

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

[SanSan83]

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,

[willharris24]

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

[MarkPalmberg]

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

[MarkPalmberg]

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]

@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]

Regards,

[svella]

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

[v-sihou-msft]

@svella

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

Regards,