Line break in a visual

[Chapin4u]

Hi, I'm trying to do a line break in a visual using unichar(10) but it's not working for me. It's possible to use a line break in card visual? This how I wrote the measure for the card:

Card Hotel Ave = SELECTEDVALUE(List[Grupo],"Todos")&": "&UNICHAR(10)&IF(SELECTEDVALUE(Hotels[currency],"Todos")="US$",FORMAT([Hotel Average Price],"$#,###.00"),IF(SELECTEDVALUE(Hotels[currency],"Todos")="GTQ","Q"&FORMAT([Hotel Average Price],"#,###.00"),FORMAT([Hotel Average Price],"#,###.00"

Thanks 

[ChrisIrvin]

Follow UNICHAR(10) with " ", like this:

"ABC" & UNICHAR(10) & " " & "DEF"

Result:

ABC

DEF

Hope that helps.

[Anonymous]

I have managed to get a line break using UNICHAR(10) & UNICHAR(10240)

[Nadim131]

Turn off word wrap, and perhaps it will work for you. It will not look pretty though, if you have a different title background.

[nimitchell]

I have a solution to add new lines, separating text cells from a table. It is explained in more detail in my stack overflow post:

Link to my solution

It boils down to using `CONCATENATEX` on the cells that should be concatenated, providing the `UNICHAR(10)` statement as separator:

CONCATENATEX(FILTER(Sheet1, [Column1]<>"Overview"), Sheet1[Column2], UNICHAR(10)))

--> That is the defining line that can be seen in my screenshot on StackOverflow.

EDIT: another user on SO suggested that this requires Release October 2017 and din't work on earlier versions!

[v-huizhn-msft · Accepted solution]

Hi @Chapin4u,

After research, we can not add line break in text directly, because Power BI always strips line breaks out of text when it gets loaded into the Data Model. unichar function returns the Unicode character that is referenced by the given numeric value. unichar(10) return a unicode in your measure, and it is recognised by a text. So it is not working for you. As I tested, unichar(10) returns nothing. What's your expected result? Please review more details about UNICHAR in this blog.

Best Regards,
Angelia

[Chapin4u]

Thanks Angela for the explanation.