Search text from a list in a column with delimiters

[Anonymous]

Hi all, 

I am quite new on this platform so sorry in advance if you this sounds like a simple issue but I did not manage to find an answer to my problem online. 

Here it is:

I have a column that contains all the products our customers are using, each of these products being separated with a comma. I want to filter the rows based on a list I created ? I managed the easy trick of adding a conditional column but that covers only one word. 

Do you have any idea how to proceed ? 

Thank you very much in advance for your help ! 

[Icey]

Hi @Anonymous ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @Anonymous ,

I'm not quite sure what you want. Please check if this is what you want.

1. Enter a SlicerTable.

2. Create a measure.

Measure = SEARCH ( SELECTEDVALUE ( SlicerTable[Product] ), MAX ( 'Table'[Products] ),, BLANK () )

3. Put the Measure on the visual you want to fiter.

Then, you can get this:

Or, you can use "Text Filter".

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Saurabh8437]

Can you share the Pbix file here along with sample raw data and created list to check further?

[Anonymous]

Hi, it would look like this:

Customer Name	Products
A	tires, racing pump, software, water
B	water, shield, oil, brakes
C	brakes, tires
D	brakes, tires, pump, software, water, shield

A my filter list sits in an excel file: 

water

pump

shield

For information, I just tried to use the list option in the conditional column but it flagged everything. 

Thanks in advance, 

[Saurabh8437]

 

I managed to get this result using power query. Will it do? 

[Anonymous]

Thanks for your answer, this is a good option. Ideally, I would like to have "yes" or "no" if any of the listed items are found in the column. How would I set that up ? 

Thanks in advance and regards,