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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

I haven't figured out a way to get line breaks to appear where I want them and have tried a kinds of things like ASCII characters, etc. If you figure it out, I'd be very interested.

  • mork's avatar
    mork
    Helper V
    10 years ago

    My gut tells me the right special characters are #(cr)#(lf) but they don't work at the moment.

     

    Greg_Deckler Do you have a workaround maybe? A way to better show text without line breaks?

    • FawadRehman's avatar
      FawadRehman
      Helper I
      10 years ago

      I have been trying to use all the solutions available on the net but still no luck. Any Help from power BI guys? 

       

      Full Contact = LOOKUPVALUE(' Contacts'[Manager Name],' Contacts'[Id],'Customer Contact'[ ContactId])
      & " " & LOOKUPVALUE(' Contacts'[Email],' Contacts'[Id],'Customer Contact'[ ContactId])
      & " " & LOOKUPVALUE(' Contacts'[Telephone],' Contacts'[Id],'Customer Contact'[ ContactId])

       

      here's my code. 

      • sornavoor's avatar
        sornavoor
        Resolver I
        10 years ago

        Suggest that you raise it as a bug for the data import team to look at - at their leisure.  we are able to see the line break in the text  when looking at the data in Advanced editor .... but does not seem to get into the table from there :smileysad:  Thinking pacman is eating them up!