Show related entries on another slicer

[Tavares]

So I'm trying to do something and a I'm not being able to. I'm using directquery on a table that has a column with a code and a column with a description. The same code can have multiple descriptions:

|Code | Description

| 1      | Red pen

| 2      | Blue pencil

| 1      | Blue pen

| 2      | Green pencil

| 3      | Green brush

| 2      | Brown pencil

I have a slicer for the column description but sometimes the user may select "Red pen" but may want to see "Blue pen" instead or the both of them together. I don't want to have a slicer for the code because some users don't know the code by memory.

I thought maybe having a different slicer appear with only the descriptions that have the same code.

So , If I select "Red pen", the other slicer shows "Red pen" and "Blue pen" only.

I don't know how to do this, can someone please help?

[v-huizhn-msft]

Hi @Tavares,

Slicer is used to filter rows. When you select "Red pen" in slicer including [description] column, it will display "Red pen" rather than "Blue pen". For your requirement,  when you select "Red pen", the other slicer shows "Red pen" and "Blue pen" only., which is impossible.

Best Regards,
Angelia