Forum Discussion

JohnnyK's avatar
JohnnyK
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Slicer to indicate missing values in rows

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 fro...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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.

     

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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.