cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shelley Member
Member

How to add a line break in a text concatenation

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:MMSmiley FrustratedS")
    &  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!

1 ACCEPTED SOLUTION

Accepted Solutions
Shelley Member
Member

Re: How to add a line break in a text concatenation

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:MMSmiley FrustratedS")
    &  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.

4 REPLIES 4
Shelley Member
Member

Re: How to add a line break in a text concatenation

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:MMSmiley FrustratedS")
    &  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 Frequent Visitor
Frequent Visitor

Re: How to add a line break in a text concatenation

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 :-/

Shelley Member
Member

Re: How to add a line break in a text concatenation

@CYParker I think it was in a Card visual.

CYParker Frequent Visitor
Frequent Visitor

Re: How to add a line break in a text concatenation

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.

 

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 374 members 4,192 guests
Please welcome our newest community members: