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
Vicky_Song's avatar
Vicky_Song
Impactful Individual
10 years ago

mork, please have a check on arify's solution to see whether it works. If you still need further help, please post back.

Johnnyg's avatar
Johnnyg
Frequent Visitor
10 years ago

arify / Vicky_Song -

 

I am not sure this thread is closed or the issue has been resolved....

But, I can reproduce the issue - that New Line or formatted text values ( fields created with special charactures #(cr)#(lf) or #(tab))

show up as formatted values in Power BI - Power Query, but the formatting is lost after the query is applied.

I am a newbe, so I may be wrong, but I have the same desired outcome as to want to display in a Text Visual a formatted string

For example:

John P. Jones
1121 S Andrews St
Faraway, NM, 09876
(123) 456-7890

 

I can create the field in Query Editor, but the formatting #(cr)#(lf) are lost when moving to the data view or in visualizations.

 

Is there a fix for this, or am I missing something in my approach.

 

Thanks for any guidance!!!