Carry over superscript formatting from Excel to Power BI

[Jason2023]

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:

[ajaybabuinturi]

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]

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 · Accepted solution]

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.

[Jason2023]

This got me the exact result needed - much appreciated!

[ajaybabuinturi]

Please accept a solution and give kudos

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.