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
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 :(