Forum Discussion

Chapin4u's avatar
Chapin4u
Microsoft Employee
9 years ago
Solved

Line break in a visual

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 Hote...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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


tenea_a's avatar
tenea_a
New Member
5 months ago

Hi,
After reviewing a few answers here and combining solutions, I have found that this syntax for creating a measure works:

VAR VALUES_TO_DISPLAY =
CONCATENATEX( TABLE_NAME, COLUMN, UNICHAR(10) )
RETURN
IF(ISFILTERED(COLUMN), VALUES_TO_DISPLAY, "alt_text")

In this example values from the filtered column can be shown with a line brake in card visuals when Format Visual settings -> Callout ->Value -> [Text wrap] is toggled on.