I have a Sharepoint list with an enriched text column. Since it is an enriched text column, folks can use bullet points in their entries. They look great on Sharepoint but when the information goes into PowerBi, it shows up as HTML on all the visuals. For our purposes, we just need to showcase the information on a table.
Question, is it possible to use DAX or some other process to transform the data in that enriched text column so that the table visual can show the bullet point hierarchy?
Currently, the enrich text column shows up like this in the table visual:
Seeking help to keep the bullets and make it look as close as possible to how it looks in the Sharepoint list:
Yes, it is possible to transform the data in the enriched text column to show the bullet point hierarchy in Power BI. However, Power BI doesn’t natively support HTML rendering in its visuals, so the HTML tags from the enriched text column in SharePoint will appear as plain text.
Here are a couple of options you might consider:
Strip out all HTML markup: You can create a new column in Power Query where you use a text transformation function to strip out the HTML tags. This won’t preserve the bullet point hierarchy, but it will clean up the text.
Use a custom visual that supports HTML content: There are custom visuals available in the Power BI marketplace that support HTML content. This could allow you to preserve some or all of the formatting from the enriched text column.
Please note that these solutions might not perfectly replicate the look of the bullet points and other formatting from SharePoint, but they can help make the text more readable in Power BI.