Forum Discussion
"IN" operator missing in Power Query filters
Hi satishorre20 ,
I understand that it might be a bit unclear, so let me provide more details.
When you're applying a filter in Power Query and the "In" filter option isn't visible in the main filter menu, here's what we can do:
- If the "In" filter isn't visible in Power Query. Apply any filter to the column (e.g., Text or Number filter).
- In the Query Settings pane, click the gear icon next to the filter step.
- In the filter dialog, select "In" from the dropdown and enter your values.
- If In operator is not visible,try using below:
create a custom column with List.Contains({"Value1", "Value2"}, [ColumnName]) and filter based on that column.
I hope this helps you.if so consider accepting it as solution.
Thank you for your cooperation.Have a great day!
Regards,
Pallavi.
Thank you Deku , Chewdata , Anonymous for the response.
I am trying to use multi value parameter as a filter. If we use List.Contains with parameter name, it picks only default value. it is not picking up all list values from the parameter. The documentation says there is "in" operator. I am not sure why it is not showing up.
Parameters are only a single value, the list
You can define a list instead of a parameter and pass that in instead
you can look at the documentation https://learn.microsoft.com/en-us/power-query/power-query-query-parameters
Is anyone understand the below statement?
For some of the other data types, the In filter might not appear in the main filter menu. Select any other filter option and then edit the filter under Query settings. Then, from the filter dropdown in the editor, select In.
Hi satishorre20 ,
I understand that it might be a bit unclear, so let me provide more details.
When you're applying a filter in Power Query and the "In" filter option isn't visible in the main filter menu, here's what we can do:
- If the "In" filter isn't visible in Power Query. Apply any filter to the column (e.g., Text or Number filter).
- In the Query Settings pane, click the gear icon next to the filter step.
- In the filter dialog, select "In" from the dropdown and enter your values.
- If In operator is not visible,try using below:
create a custom column with List.Contains({"Value1", "Value2"}, [ColumnName]) and filter based on that column.
I hope this helps you.if so consider accepting it as solution.
Thank you for your cooperation.Have a great day!
Regards,
Pallavi.
