Forum Discussion

Frequent Visitor

4 years ago

Solved

Filter with in operator

Hi all,

I want to use "in" filter such as ms SQL Where Shipment in (1234,5689,9856)

How do I do in Power BI?

For example; I have 50 shipments number. (They're dynamic shipments.)

I want to filter 50 shipments in all shipments.

Is it possible?

BTW, I use DirectQuery.

Thanks.

Erdem

TheTeam35
4 years ago
Hi,

The report has more than 30K shipments.
I want to search sometimes 50 shipments 100 shipments.
I want to copy and paste shipments in a filter or slicer and get the report.
So, how can I do this?

Thanks.
v-easonf-msft
4 years ago
Hi, TheTeam35

You can try use 'Filter by List' Custom Visual. The 'Filter by List' visual allows you to easily copy and paste in a list of values that you wish to filter on your report.

Best Regards,
Community Support Team _ Eason

5 Replies

AlexisOlson
Super User
4 years ago
You can use the IN syntax in DAX as well.

For example,

FILTER ( Shipments, Shipments[Number] IN {1234,5689,9856} )
TheTeam35
Frequent Visitor
4 years ago
Hi,

After publishing the report, the user how do they do it?
I want the users to change the shipment numbers when they get the report.

Thanks.
- Samarth_18
  Community Champion
  4 years ago
  Hi TheTeam35 ,
  
  If I am taking your question correctly then you could add filter or slicer(with multi select option enable).
  
  BR,
  
  Samarth
  - TheTeam35
    Frequent Visitor
    4 years ago
    Hi,
    
    The report has more than 30K shipments.
    I want to search sometimes 50 shipments 100 shipments.
    I want to copy and paste shipments in a filter or slicer and get the report.
    So, how can I do this?
    
    Thanks.

Related content