Power Query map one column from a table to three columns of another table

I am working on a dashboard for Netflix movies/series. I have a table A with columns as shown -

I need a Genre Slicer on the top of dashboard to filter movies of that genre.

I am thinking of making an another table B with column Only_Genre such as -

and separating the Genre column from table A into different columns as shown -

and then mapping Only_Genre of table B to Genre, Genre2 and Genre3 of table A.

But I am unable to do so in power query. Can anyone please help? Or any other workaround for the job can also work. Thanks.

Solution

I'd suggest making table B like this:

Then you can create a relationship on Genre and use Single Genre for your slicer. You'll want it to be many-to-many where B filters A.