Forum Discussion

TheTeam35's avatar
TheTeam35
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 ...
Need Help
  • TheTeam35's avatar
    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's avatar
    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

TheTeam35's avatar
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's avatar
    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's avatar
      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.

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        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