Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to get text in new line using data cards

Hello all,

 

Is there anything like forcefully getting values into new line..

Per suppose i have 4 sales type of values.
I would like to show each sales type and their values into 4 lines..

 

we have something like wordwrap but it wont work for all the time.

Do we have unichar no for braking line and getting values into newline.

 

Any help

Mohan V

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous,

 

Seems it doesn't work on the card visual yet.. But here is a workaround. It works with a combination of word-wrap and the UNICHAR(10), so measure remains the same.

 

Use a table or matrix visual, put the measure in and rename the measure in the visual to " " set the outline color to the same as the background, enable word-wrapon values and it is allmost like the card visual. Probably it will be supported in the near future.

 

multiline.JPG

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi Mohan,

 

Since the Power BI July update there is support for the UNICHAR that represent a new line:

 

Measure with newline = "This is the first line" & UNICHAR(10) & "This is the second line"

Check https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/ for more info

Anonymous
Not applicable

Thanks for the reply @Anonymous.

 

I jus tried this but no luck..

Its not working.

1.PNG

 

My powerbi Desktop details..

2.PNG

 

Am i missing anything here..

Anonymous
Not applicable

Hi @Anonymous,

 

Seems it doesn't work on the card visual yet.. But here is a workaround. It works with a combination of word-wrap and the UNICHAR(10), so measure remains the same.

 

Use a table or matrix visual, put the measure in and rename the measure in the visual to " " set the outline color to the same as the background, enable word-wrapon values and it is allmost like the card visual. Probably it will be supported in the near future.

 

multiline.JPG

Anonymous
Not applicable

Thanks @Anonymous

it works..

great....:)

 

can you give any suggestion regarding the unichar no for tab space.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.