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.
Says this in those docs
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
Otherwise use list.contains
Frankly, I didn't understand this statement. Do you know how to see "Select any other filter option"?
