Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Rich text/HTML formatting in PowerBI table

Hi all,    I currently have an important that comes with HTML mark-up due to how it is input into a database; so lots of <p> and <b> and a huge chunk of text that is generally unreadable.    Is t...
Need Help
faheem_Latif_BI's avatar
faheem_Latif_BI
Helper I
2 years ago

Please create custom coumn and use this code , and enjoy

if [HMTLField] = null then null else   Html.Table([HMTLField] , {{"text",":root"}})

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi thanks this worked for me. However the html format had bullet points hence, every new sentence was on new line. Is there any way I can maintain this (Html.Table([HMTLField] , {{"text",":root"}}) structure after this step?

    • anusha_2023's avatar
      anusha_2023
      Helper IV
      1 year ago

      Hi! I am trying to create Custom column to recognize rich text in this similar way and I am having issue. Wolud you mind to share your input here. Thanks

       

  • occams_razor's avatar
    occams_razor
    New Member
    2 years ago

    This worked for me, thanks!

    • anusha_2023's avatar
      anusha_2023
      Helper IV
      1 year ago

      Hi! I am trying to create Custom column to recognize rich text in this similar way and I am having issue. Can you please share your input here. Thanks