Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper 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
Icon for Impactful Individual rankImpactful 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!!!

  • arify's avatar
    arify
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Hi Johnnyg, when I checked it, at first it looked like one line, but the new line character is actually still there. What visualization are you using? Can you try to expand the size of the row vertically?

  • Johnnyg's avatar
    Johnnyg
    Frequent Visitor
    10 years ago

    I have used a couple with the same results: LongTextViewer,  Table (standard with PowerBI).

     

    The field value in Query Editor displays:

    Edward

    Jones

     

    The Data Views displays:

    Edward Jones

     

    The Visuals (both) displays:

    Edward Jones        (independent of the column/field width.

  • arify's avatar
    arify
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Can you please send a frown with that, and make sure you include the information in your last message (and maybe a link to this thread)?

     

    Thanks

  • Johnnyg's avatar
    Johnnyg
    Frequent Visitor
    10 years ago

    Done...Thanks!