Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display text without HTML code, but with formatting

Hi,

 

I loaded the data from the Sharepoint list into Power BI. The text fields were in HTML format. E.g.
<div class = "ExternalClassDB4D9 ....."> <div> <div> Q1 <br> ....
To remove the HTML code, I used the FieldValuesAsText function, but got plain text. All text formatting is gone. There is a lot of text, so it has to be displayed from new lines somewhere and so on.
Is it possible to leave HTML code that preserves formatting but display in a dashboard without HTML code? Text only?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Currently Power BI does support Rich text field. Just change the data type of field to plain text in Sharepoint itself.

    Other way is you can use HTML content custom visual, but it does not support export to pdf or ppt format.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Currently Power BI does support Rich text field. Just change the data type of field to plain text in Sharepoint itself.

    Other way is you can use HTML content custom visual, but it does not support export to pdf or ppt format.