cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

0

How do I get a table to correctly show the bullet points used in a Sharepoint enriched text?

Hi All, 

 

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: 

Slpz22_0-1695771419420.png

 

Seeking help to keep the bullets and make it look as close as possible to how it looks in the Sharepoint list: 

Slpz22_1-1695771607600.png

Thank you!

Status: Delivered

Hi @Slpz22 ,

 

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.

 

Solved: Rich text/HTML formatting in PowerBI table - Microsoft Fabric Community

Use inline hierarchy labels in Power BI - Power BI | Microsoft Learn

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi @Slpz22 ,

 

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.

 

Solved: Rich text/HTML formatting in PowerBI table - Microsoft Fabric Community

Use inline hierarchy labels in Power BI - Power BI | Microsoft Learn

 

Best regards.
Community Support Team_Caitlyn