topic Re: How to enter Line Breaks in HTML Content Visual? in Custom Visuals Development Discussion

How to enter Line Breaks in HTML Content Visual?

Sarnie_a — Mon, 23 Oct 2023 13:31:27 GMT

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 🙂

Re: How to enter Line Breaks in HTML Content Visual?

Greg_Deckler — Mon, 23 Oct 2023 13:37:06 GMT

@Sarnie_a Generally it's <br>

Re: How to enter Line Breaks in HTML Content Visual?

Sarnie_a — Mon, 23 Oct 2023 13:38:57 GMT

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

Re: How to enter Line Breaks in HTML Content Visual?

Greg_Deckler — Mon, 23 Oct 2023 13:41:51 GMT

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

Re: How to enter Line Breaks in HTML Content Visual?

Sarnie_a — Mon, 23 Oct 2023 13:45:27 GMT

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

Thank you 😀