Slicer to indicate missing values in rows

Question

Good day!&nbsp;&nbsp;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].&nbsp;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:&nbsp;&nbsp;I tried but I can only use 1 missing color (when more colors put in, it shows a hierarchy).&nbsp;What's the way that it can be done? Thank you.&nbsp;(Data as below.)NameDataHas blueHas brownHas greenHas redHas yellowDavidGreen, red, yellowMissing blueMissing brown&nbsp;&nbsp;&nbsp;KateRed, blue&nbsp;Missing brownMissing green&nbsp;Missing yellowMikeBrown, yellowMissing blue&nbsp;Missing greenMissing red&nbsp;

jihwan_kim · Accepted Answer

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.

&nbsp;
&nbsp;
&nbsp;

&nbsp;

Forum Discussion

Slicer to indicate missing values in rows

2 Replies

Related content

missing data

Missing Dropdown Option in Slicer

missing data

Generating Missing Data

Inferring Missing Columns and Imputing Missing Data

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