How to add a line break in a text concatenation

[Shelley]

I'm trying to add a line break in a concatenated text strong and have tried

<br/>

"<br/>"

UNICHAR(10)

and cannot get it to work. Does anyone know how?

Here's the expression:
Last Refresh =
CONCATENATE("Last Refresh: " & FORMAT (MAX('Last Refresh Local Time'[Last Refresh Local Time]), "mm/dd/yyyy at HH:MM:SS")
    &  UNICHAR(10) &
"Latest Service Ticket: ", FORMAT(MAX('ServiceTicket'[Create Date]), "Short Date"))

This results in:

Last Refresh: 03/22/2018 at 13:54:12 Latest Service Ticket: 3/21/2018

I want:

Last Refresh: 03/22/2018 at 13:54:12
Latest Service Ticket: 3/21/2018

Thanks for any help!

[joglidden2]

Just to add to this thread, if using this (mad genius) technique in an x-measure, you just put in UNICHAR(10) in the delimiter field, as in, 

_IP_Values = CONCATENATEX(VALUES(collector_view[IP]), collector_view[IP], UNICHAR(10)). 
It works!

[Anonymous]

X=

CONCATENATE(CONCATENATE('Table'[Column 1], "

"),

'Table'[Column 2])

[Shelley · Accepted solution]

I finally figured this out! The formula I had was correct.

Last Refresh =

CONCATENATE("Last Refresh: " & FORMAT (MAX('Last Refresh Local Time'[Last Refresh Local Time]), "mm/dd/yyyy at HH:MM:SS")
    &  UNICHAR(10) &
"Latest Service Ticket: ", FORMAT(MAX('ServiceTicket'[Create Date]), "Short Date"))

However, in order to have it work, I had to go to the paint roller (format) section and turn Word Wrap ON.

[CYParker]

Hi @Shelley ,

Where were you using this data? 

Being able to use a linebreak like this would be useful for me too, but I'm trying to use it on a column which I'm using for an x axis for a visualisation.

I couldnt see a word wrap option for the x axis 😕

[Prajwal934]

Hi @CYParker ,

Did you able to get solution for your problem?
If yes please let me know the solution.

[CYParker]

Hi @Prajwal934, I don't think I found a solution to my issue. 

[Shelley]

@CYParker I think it was in a Card visual.

[CYParker]

Hi @Shelley,

Thanks for getting back to me and sharing what you learnt. 

I was trying to get it to work for use in an X axis on a graph but it doesnt seem to work for that.