Forum Discussion

Sarnie_a's avatar
Sarnie_a
New Member
2 years ago

How to enter Line Breaks in HTML Content Visual?

Hi

 

I am pulling a HTML string from a Repeating Section in SharePoint List. The HTML string in particular is pulling through fine.

When I pull this through as a visual (through HTML Content) in PowerBI, it is all one long text and isn't very readable. 

 

Is there a way, to break the text so its shown in paragraphs? 

 

I have tried adding in a character (in this instance "\n") in the SharePoint forms text at the end of each paragraph, and then trying to use the SUBSTITUTE function, but it does not pull through to the visual. 

 

Thanks in advance 🙂

4 Replies

  • Sarnie_a's avatar
    Sarnie_a
    New Member
    2 years ago

    It appears to have worked with just the <br> in the actual SharePoint form.

    Thank you ğŸ˜€

  • Sarnie_a's avatar
    Sarnie_a
    New Member
    2 years ago

    Thank you Greg_Deckler - Would i still need to use the SUBSTITUTE in DAX or will that pull directly from SharePoint HTML String? 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      2 years ago

      Sarnie_a Oh, sorry, read that completely wrong. <br> is for HTML line breaks. I thought you were using an HTML display visual. If you want line breaks in Power BI Desktop in like a table or matrix visual you can use "UNICHAR(10) & UNICHAR(13)" for you substitution. Note, you need to substitute both of those in just like in the double quotes.