"IN" operator missing in Power Query filters

[satishorre20]

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 "Multi-value or list parameters" documentaiton in the page https://learn.microsoft.com/en-us/power-query/power-query-query-parameters)

current version of Power BI Desktop is   2.140.1205.0 64-bit (February 2025)

How do we enable "in" and "not in" operator in Power Query filter? 

[v-pagayam-msft]

Hi @satishorre20 ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @satishorre20 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-pagayam-msft]

Hi @satishorre20 ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[satishorre20]

Thank you @Deku , @Chewdata , @v-pagayam-msft  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. 

[satishorre20]

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.

[v-pagayam-msft · Accepted solution]

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.

[Deku]

Parameters are only a single value, the list 

You can define a list instead of a parameter and pass that in instead 

[satishorre20]

you can look at the documentation https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

[v-pagayam-msft]

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!

[Chewdata]

Hey!

I think that for filtering List.Contains(list, [column]) and List.Contains(list, [column]) = False are the way to go as options for in and not in

[Deku]

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

[satishorre20]

Frankly, I didn't understand this statement.  Do you know how to see "Select any other filter option"?