Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello everyone,
I just upgraded to excel 2021, and while I appreciate the editor improvements, I have a BIG PROBLEM with the custom column editor. When I commit my custom column formula row, everything goes fine, however, if I want to modify my formula, the editor callback shows white text on a white background, and therefore unworkable. The only solution is to go back to excel and reopen powerquery, and I only have one chance because the phenomenon recurs each time. Is this problem known and is there a solution? Thank you to all of you
Philippe Muniesa (french user)
Solved! Go to Solution.
Hello, Thank for your respons,
I found a curious solution after a lot of tries (changing screen resolution, dark mode or not etc etc).
Just right-clicking in the "custom column" window makes the text reappear, from the column formula, which then becomes editable again.... I don't know if this will work for you, but if it does is the case .. I would love to. Regards, and good luck for the future.
Philippe Muniesa
Hello, Thank for your respons,
I found a curious solution after a lot of tries (changing screen resolution, dark mode or not etc etc).
Just right-clicking in the "custom column" window makes the text reappear, from the column formula, which then becomes editable again.... I don't know if this will work for you, but if it does is the case .. I would love to. Regards, and good luck for the future.
Philippe Muniesa
I faced the same issue, then I restarted the Power BI application, Now it's working as expected.
My solution to the problem was;
Go to File in excel---------> Option ---------> General---------------> Office theme, and choose (Use system setting)
Thank you! This just worked for me and will be using it in the future!
I've had the problem also, from time to time. Not too often. And I can't figure out how to reproduce it. But if I exit PQ and then re-open, it usually works again.
Yeah, this happens to me all the time, and I end up having to copy and paste into Notepad, write my formula, then copy it back. This has been a thing for at least a few years.
--Nate
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
13 | |
10 | |
8 | |
7 |
User | Count |
---|---|
17 | |
10 | |
7 | |
6 | |
6 |