cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
benjamin_sasin
Resolver I
Resolver I

Form-styled new column popup shows instead of standard new column formula popup

First I create a new column with this standard popup where I can type my formula:

2020-05-12 (5).png

 

But then ehwn I want to edit the column, I'm getting this annoying format:

2020-05-12 (4).png

 

How can I edit using the classic formula screen, I just want to to code. This popup is not adequate at all.

 

Any setting I should change?

1 ACCEPTED SOLUTION

Hi @benjamin_sasin ,

 

Yes, I can reproduce your issue using IF function to create custom column.  If you need to see and edit the codes, just click the step "Add custom" , then go to View-> Formula Bar.

formula bar.png

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-xicai
Community Support
Community Support

Hi @benjamin_sasin   ,

 

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

Hi,

 

This is not what I mean.

 

I clearly added a custom column by typing code in the code input area of the standard new colum prompt. However, because I typed an IF...THEN clause, when I click on the same step to edit, it show a conditional column prompt.

 

This is something new to PowerBI. I just want to edit the code and not fiddle around with drop downs and what not.

 

Hi @benjamin_sasin ,

 

Yes, I can reproduce your issue using IF function to create custom column.  If you need to see and edit the codes, just click the step "Add custom" , then go to View-> Formula Bar.

formula bar.png

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

amitchandak
Super User
Super User

@benjamin_sasin , if you click of a custom column name in the table , the formula bar should show it calculation in edit query mode?

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Yes it shows the forumula bar. However the formula bar format is not the same as the pop up format as well as the popup offers predictive text where the formula bar doesn't.

Hi @benjamin_sasin ,

 

Generally , when you click "Custom Column" button, pop-up page is like picture one, and when you click "Conditional Column" button, pop-up page is like picture two. 

105.png

 

 

 

 

 

Then it will appear the steps like names below. While the "Conditional Column" pop-up page appears in step "Added Custom1" in your scenario, you may check if you have renamed the step name  "Added Conditional Custom" with "Added Custom1"  in APPLIED STEPS pane.  or you may create a custom column again.

106.png

 

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!