Forum Discussion

mork's avatar
mork
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...
Need Help
Brian_M's avatar
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's avatar
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's avatar
    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?

    • Brian_M's avatar
      Brian_M
      Continued Contributor
      9 years ago

      I've just tried it myself, no luck sorry :(