Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add Custom Column Broken - How to solve?

Hi all,

 

I've run into this problem a few times whilst trying to add a custom column in Power Query editor. Has anyone got a fix for this? I can't type see the right hand side of the box, making code a pain to write.

 

 

Kind regards,

 

Jordan 

10 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion

    which version of desktop are you using ?

    haven't faced such issue in August 2020 update.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi FarhanAhmed, I'm also using August 2020 and have had this many times!

       

      Kind regards,

       

      Jordan  

  • Hi Anonymous ,

     

    I just tried this at my end, but I don't see such issue.

    As sonn as there is no space on 1st link, the cusor by default gows to the 2nd line by allowing me to write the code there.

    In the highlighted section below, I continued writing the code and the curson went by-itself to next line.

    See below:

     

    Are you on the latest version of Power BI Desktop?

     

    Thanks,

    Pragati

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Pragati11,

       

      I know it goes to a second line, but you'll notice that the available columns reaches far into my textbox. 

       

      Kind regards,

       

      Jordan

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        Anonymous - Do you have an excessively long column name by chance? Scroll down through your list of available columns.

  • Anonymous 

    Working on coding in Formula bar and in the Advanced Editor is another option. Advanced Editor makes it more convenient.

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn