Forum Discussion
powerquery custom column editor invisible text
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)
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
6 Replies
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
Thank you! This just worked for me and will be using it in the future!
My solution to the problem was;
Go to File in excel---------> Option ---------> General---------------> Office theme, and choose (Use system setting)
I faced the same issue, then I restarted the Power BI application, Now it's working as expected.
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.
