Edit Query Filter

[JasKki]

Hi,

In Edit Query, am I able to:

1. Perform a Filter in Column "A" E.g. Filter to only show "5" 

2. Replace certain values in Column "B" E.g. Replace "Apple" with "Orange"

3. Clear Filter for Column "A"

4. Perform another Filter in "Column "A" E.g. Filter to only show "6"

6. Replace certain values in Column "B" E.g. Replace "Apple" with "Pear" this time.

I am not able to do so as after Step 2., I am not able to clear filter in Column "A" or make it filter to show "6" instead of "5".

[v-jiascu-msft]

Hi @JasKki,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft]

Hi @JasKki,

The steps in the query editor are applied one by one, which isn't fully interactive like Excel or Power BI report view. But you still can delete some previous steps though there would be potential problems.

One more thing, you will find out the step 2 are applied in the whole query if you delete the previous step "Filtered Rows". So I would suggest add a custom column in this scenario.

if [Column A] = 5 and [Column B] = "Apple" 
then "Orange" 
else if [Column A] = 6 and [Column B] = "Apple" 
then "Pear" 
else [Column B]

Best Regards!

Dale

[GilbertQ]

Hi @JasKki

To me it would be because you have filtered the column A in step 2, that filter will still apply, due to it being applied in the order of the steps in the Query Editor.