Forum Discussion

Jason2023's avatar
Jason2023
New Member
10 months ago
Solved

Carry over superscript formatting from Excel to Power BI

I am trying to figure out how to maintain the superscript formatting when bringing data in from Excel to Power BI. I have the data formatted as below within Excel however when I load data it reverts back to original formatting.

If this is not possible given Power BI's limitations - is there a DAX function or some way within Query Editor to apply the superscript formatting to my text without having to use the superscript option in a text box?

 

Desired Result:

How it currently looks in Query Editor:

 

Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    10 months ago

    Hi Jason2023 ,


    I am not sure how it will helps you but you can try with creating a custom column and paste below provided code in the custom column pop up box and replace your column with your actual column name.

    // Add this as a New Custom Column formula in Power Query
let
    txt = [YourColumn],
    replacements = {
        {"0","⁰"},
        {"1","¹"},
        {"2","²"},
        {"3","³"},
        {"4","⁴"},
        {"5","⁵"},
        {"6","⁶"},
        {"7","⁷"},
        {"8","⁸"},
        {"9","⁹"},
        {"(n)","(ⁿ)"},
        {"+","⁺"},
        {"-","⁻"}
    },
    result = List.Accumulate(replacements, txt, (state, r) => Text.Replace(state, r{0}, r{1}))
in
    result

     

     

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

5 Replies

  • ajaybabuinturi's avatar
    ajaybabuinturi
    Icon for Super User rankSuper User
    10 months ago

    HI Jason2023,

    Power BI’s data model (VertiPaq engine) does not store or render rich text formatting. The model simply strips the rich formatting, because there’s no concept of superscript, subscript, bold within Power BI column data. Even when you use Power Query, the data preview and loaded table show plain text only.

    So, unfortunately, you cannot preserve the Excel superscript formatting directly in Power BI tables or visuals. 

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

    • Jason2023's avatar
      Jason2023
      New Member
      10 months ago

      I do find this solution helpful in terms of narrowing down my options however I would like to ideally accomplish this within Power Query, DAX, or another method not mentioned. I want to try to avoid using text boxes so that I can update the data and have it carry over automatically without needing to individually update each text box. 

       

      Is it possible to accomplish the superscript formatting using one of the above methods?

      • ajaybabuinturi's avatar
        ajaybabuinturi
        Icon for Super User rankSuper User
        10 months ago

        Hi Jason2023 ,


        I am not sure how it will helps you but you can try with creating a custom column and paste below provided code in the custom column pop up box and replace your column with your actual column name.

        // Add this as a New Custom Column formula in Power Query
let
    txt = [YourColumn],
    replacements = {
        {"0","⁰"},
        {"1","¹"},
        {"2","²"},
        {"3","³"},
        {"4","⁴"},
        {"5","⁵"},
        {"6","⁶"},
        {"7","⁷"},
        {"8","⁸"},
        {"9","⁹"},
        {"(n)","(ⁿ)"},
        {"+","⁺"},
        {"-","⁻"}
    },
    result = List.Accumulate(replacements, txt, (state, r) => Text.Replace(state, r{0}, r{1}))
in
    result

         

         

        Thanks,
        If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.