Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
PhilippeMuniesa
Resolver I
Resolver I

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)

1 ACCEPTED SOLUTION
PhilippeMuniesa
Resolver I
Resolver I

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

View solution in original post

6 REPLIES 6
PhilippeMuniesa
Resolver I
Resolver I

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!

ronrsnfld
Super User
Super User

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
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.