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