Search for multiple values with CONTAINS, not exact values

[tkramer]

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 where they could search the 3 values, select them all, and then done.  However, I need the filter to be a CONTAINS filter and not exact text values because there are prefixes/suffixes at the end of these Product Numbers.  You can achieve this by using the Filter Pane on the right with "Advanced filtering".  However, it only allows 2 different values.  See screenshot below: 

So, I tried looking into some other visual options and found from the AppSource: MassFilter by Insiders.coop and the Text Filter by Microsoft.  The Mass Filter allows you to copy/paste or type out multiple values which is great, but these values have to be an EXACT MATCH which does not work.   The Text Filter has CONTAINS functionality which is great, but I can only type in one value at a time.  

In summary, I need a way to show items when the value in the Product Number column CONTAINS VCBB5363 or VCFB5363 or VCRB5363.  Please let me know if anybody has any ideas on how to achieve this.  This needs to be dynamic, as the desired Product Numbers will change often and may be 10 or more different values.  Help is much appreciated!

[Timuran]

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]

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]

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]

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.