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 !! YouTube Channel !! Connect on Linkedin

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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!