Filter based on multiple columns

[Anonymous]

I have a Data table that looks like in the picture below. I have one column with unique IDs and one column with a text string. The text string contains different combinations of a code. I want to be able to filter the table based on if one (or several) of the codes contains in the text string.

I have manually created new conditional columns for each code.

Is there a way to have a simple “filter table” connected to the Data Table and filter the Data Table with this filter table? How do I do this?

Grateful for help!

[amitchandak · Accepted solution]

@Anonymous , if you have only the first two columns. My advice would split the second column  into rows in power query

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

[Anonymous]

Thank you so much! That works perfectly!