Forum Discussion
Helper II"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.
Hi satishorre20 ,
Thank you Chewdata and Deku for valuable inputs!
The responses clearly explain how to enable the "In" filter in Power Query. As suggested, the "In" operator may not always be visible in the UI, but you can achieve the same filtering by adjusting the filter in Query Settings or using List.Contains() in a custom column. These are the most effective methods that may help you to get the desired results.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you for being a valued member of the Microsoft Fabric Community Forum!