Forum Discussion
Solved
"IN" operator missing in Power Query filters
Good afternoon, I am trying to find the option to see "in" clause filter in Power query. As per the documentation, I see "in" operator is available to use multi-value parameters ( please refer "...
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.
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