Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

When loading an excel file from sharepoint, how to create a new column if a data is in bold format ?

Hi all,

 

I have to load an excel file located in Sharepoint into PowerBI. I can't modify this excel file. However, some data in one column are in bold format. Is there any way, in PowerQuery, when I import the file, to create a new column with the bold format data, and another column with the normal format data ?

 

Thank you in advance for your help.

Regards,

 

Alice

Need Help

4 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    I'm not aware of any way for Power Query to distinguish bold text and normal text from an Excel source. If you had tags like HTML <b></b>, you could do it but I don't think the Excel connector preservers font formatting.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you for your answer, indeed there are no such tags in the query...

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

    You cannot change the font to bold on specific column but with the conditional formatting, 

    The only formatting option you will have is as in the formatting tab of the chart. Here you can drop down select the row for formatting. See conditional formatting here

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you, but this is not the question.