Tool tip line breaks

[Zirva]

I am trying to cutsomise tooltips and im adding the required information which is working great but i am just not able to break it to different lines despite trying chr(10) & chr(13). Currently im trying

='City: ' & CityName & chr(10) &
'Product: ' & ProductName & chr(10) &
'Opportunities: ' & Totalopportunities & chr(10) &
'Challenges: ' & Count(challenges)

I want to show all these in different lines in the tool tip. Please suggest how to do it or any alternate way to achieve this 

[TauseefKhan]

Hi @Zirva,
Use like below:
Dual(Expression1 & Chr(10) & Expression2 & Chr(10) & Expression3, Expression1)

//Expression- This is for data points what you get

Or
As your Expression:

Dual(
'City: ' & CityName & chr(10) &
'Product: ' & ProductName & chr(10) &
'Opportunities: ' & Totalopportunities & chr(10) &
'Challenges: ' & Count(challenges),
Num(Totalopportunities)
)

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

[Zirva]

Hi @TauseefKhan , 

thanks for the support but I tried this but it doesnt work. Still doesnt take each to the next line. I believe the tool tip doesnt recognise chr(10) or <br> functions. Is there any other way we can achieve a line break? 

[TauseefKhan]

Use both chr(10) and chr(13) together to create a new line in the tooltip text:

'City: ' & CityName & chr(10) & chr(13) &
'Product: ' & ProductName & chr(10) & chr(13) &
'Opportunities: ' & Totalopportunities & chr(10) & chr(13) &
'Challenges: ' & Count(challenges)

[sk88024]

Try this:

='City: ' & CityName & chr(10) &
'<br> Product: ' & ProductName & chr(10) &
'<br> Opportunities: ' & Totalopportunities & chr(10) &
'<br> Challenges: ' & Count(challenges)