How to enter Line Breaks in HTML Content Visual?

[Sarnie_a]

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 🙂

[Greg_Deckler]

@Sarnie_a Generally it's <br>

[Sarnie_a]

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]

@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. 

[Sarnie_a]

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

Thank you 😀