Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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