powerquery custom column editor invisible text

[PhilippeMuniesa]

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)

[PhilippeMuniesa · Accepted 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

[sandeepvummadi]

I faced the same issue, then I restarted the Power BI application, Now it's working as expected.

[Vachba]

My solution to the problem was;

Go to File in excel---------> Option ---------> General---------------> Office theme, and choose (Use system setting)

[searl]

Thank you! This just worked for me and will be using it in the future!

[ronrsnfld]

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.

[Anonymous]

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