Slicer to indicate missing values in rows

[JohnnyK]

Good day!

There are 2 columns of data. 1 column for names. Another column shows the colors under the names. Each name already has some colors, and at the same time, some colors are missing from [Green, red, yellow, blue, brown].

When the "Name" and "Data" put into a table, I want to use a slicer to filter the rows, when certain color is missing, like:

I tried but I can only use 1 missing color (when more colors put in, it shows a hierarchy).

What's the way that it can be done? Thank you.

(Data as below.)

Name	Data	Has blue	Has brown	Has green	Has red	Has yellow
David	Green, red, yellow	Missing blue	Missing brown
Kate	Red, blue		Missing brown	Missing green		Missing yellow
Mike	Brown, yellow	Missing blue		Missing green	Missing red

[JohnnyK]

@Jihwan_Kimamazing! thank you for the help. the question is perfectly resolved!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried unpivotting the table to have the structure like below, and then used the last column to create a slicer.