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

Re: New line Characters

Hi,

 

How do you word wrap in long text viewer. Is there a special character that i can add to text data to make sure data is displayed in new line.

Highlighted
Responsive Resident
Responsive Resident

Re: New line Characters

Yes, you can add a custom string where you want the line break (I used "(LF)" but you can use anything) and then specify this under the Newline starts with option under Format > Text for the Long Text Viewer visual (Beta v.2) 

 

HHope that helps!

Highlighted
Solution Sage
Solution Sage

Re: New line Characters

Is there still no way to get Power BI visuals to handle line breaks?

 

I have tried with an Excel source. The Excel sheet consist of a single column with a header and one row. In this row I have made a text with a couple of line breaks and then loaded the sheet into a Power BI Desktop model (march 2017 version).

 

My row show with line breaks when viewing data in Query Editor. But when I add the column to my visuals the line breaks disapear (but however show in the popup when I hover the mouse over the value).

 

I have tried using Table, Multi-row Card, Matrix and Matrix preview but neither will show the line break.

 

I also tried creating a measure, but this didn't help much. I used this formular:

Comment_Meas = CONCATENATE( VALUES(Sheet1[Comment]); "")

Is there any other way to get Power BI to accept line breaks in a text measure??

/sdjensen
Highlighted
Responsive Resident
Responsive Resident

Re: New line Characters

Have you tried the same thing but with the preview version of the Table visual with word wrap enabled?

Highlighted
Responsive Resident
Responsive Resident

Re: New line Characters

I've just tried it myself, no luck sorry 😞

Highlighted
Helper V
Helper V

Re: New line Characters

Hi @Vicky_Song,

 

I don't think this issue has been resolved. If it has, could you direct me to the solution?

 

I need to display an address like this:

 

Line 1

Line 2

City

Postcode

 

Instead of this:

 

Line 1, Line 2, City, Postcode

 

Thanks!

Highlighted
New Member

Re: New line Characters

I'm told this is available in the July 2017 release...

 

The Power BI Desktop July release has word wrap support e.g. Measure = "This is the first line" & UNICHAR(10) & "This is the second line".  Make sure you turn on word wrap for the grid/title for the visualization.  https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/

 

Highlighted
Community Champion
Community Champion

Re: New line Characters

Has anyone had any luck implementing this in the Card Visual ???

 

New Line Measure.gif

 

Highlighted
Community Champion
Community Champion

Re: New line Characters

@Sean "Any luck" yes: bad luck Smiley LOL

 

It only seems to work with the matrix and table visuals.

 

 

Specializing in Power Query Formula Language (M)
Highlighted
Helper II
Helper II

Re: New line Characters

 

@Sean - did you have to do something special to make Unichar work? I keep getting stuck with an invalid syntax error - but I can't see what I'm doing wrong. 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors