Forum Discussion
Keeping subscripts and superscripts from Excel file when importing to Power BI
Hello,
I have an excel file that contains some data that has superscripts. Once they are imported to Power BI's Power Query, they are changed to normal sized characters. Here is an example:
I want to be able to keep the subscripts format when I import the data into Power BI. Any help/suggestions is greatly appreciated. Thank you in advance!
Best,
Grace
graceweii AFAIK I don't think that is possible.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
graceweii AFAIK I don't think that is possible.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
That's too bad... but thatnk you!
A workaround is to use a superscript symbol in Excel instead of superscript formatting. To insert a symbol, go to Insert -> Symbols. Use the Subset to select Superscripts and Subscripts and then select the subscript or superscript you want to use and click Insert. It looks like Excel only goes up to 9 though.
