Forum Discussion

tkramer's avatar
tkramer
Advocate I
3 years ago

Search for multiple values with CONTAINS, not exact values

I have a request from an end-user for one of my reports.  He wants information on these 3 Product Numbers: VCBB5363, VCFB5363, VCRB5363.     Typically, I would put in a default Power BI slicer wh...
Need Help
Timuran's avatar
Timuran
Resolver I
3 years ago

Hello tkramer ,

 

An alternative would be to create a new calculated column which would make a LEFT to get the 8 firsts character of your product and add a segment on it (Add a search field if you have a lot of different product references).

 

Have a nice day

  • tkramer's avatar
    tkramer
    Advocate I
    3 years ago

    This would not work because we also have Product Numbers that have fewer characters ie. "VGR" or "RV" and some Product Numbers do not have similar structure/formatting at all from different brands.

     

    Is there not a visual/filter somewhere that allows for multiple CONTAINS statements?

    • Timuran's avatar
      Timuran
      Resolver I
      3 years ago

      You can add multiple times a filter on your product in page filter (even if you don't filter), the user will be able to do what you want.

       

      Just add two times a page filter on Prod#.

       

      I didn't find any community filter with contains on multiple values.

       

      Have a nice day

      • tkramer's avatar
        tkramer
        Advocate I
        3 years ago

        That doesn't work either.  I can add two contains statements on one filter and it works fine.  But when I add the second duplicate filter, it doesn't work correctly.  I have the screenshot of both below.  

         

        This works but only allows two values.

        When using the second Model # filter, it does not work.

         

        Thank you though.  Please let me know if you find a solution.