Forum Discussion

Helper V

10 years ago

New line Characters

Hello, I use an excel file to import some text notes into Power BI for our departments. The notes are around two paragraphs and the show fine on excel. When importing them to Power BI they appear a...

Anonymous

Not applicable

10 years ago

I had the same issue trying to display an address....ended up concatenating the address lines together then using the long text visual to display it..as that is the only one that wraps text..

New Member

9 years ago

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.

Brian_M
Continued Contributor
9 years ago
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!
- sdjensen
  Solution Sage
  9 years ago
  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??
  - Brian_M
    Continued Contributor
    9 years ago
    Have you tried the same thing but with the preview version of the Table visual with word wrap enabled?

Related content