Use a slicer to look for values and then to filter by those values

[Ohad]

Hi,

I have a table with 3 columns:

1. Order ID
2. Item name
3. Quantity

Each order ID can have more than one record like in the following example:

Order ID               Item name          Quantity

1                              Salad                     1

1                              Coffee                   1

2                              Sandwich              1

2                              Soup                     1

2                              Salad                     1

3                              Coffee                   2

I am trying to add a slicer to the report with the item name and when the user will choose salad it will not filter the data but it will check which order ID contains salad and in this case it will be 1 & 2 and it will filter the data to show only records with order ID 1 or order ID 2.

Is it possible?

Thank you in advance,

Ohad

[v-sihou-msft]

@Ohad

In this scenario, you just need to add the slicer for item name, then disable the interaction with your source table. The Order ID 1 and 2 can be cascading filtered in other visuals.

Regards,

[Ohad]

@v-sihou-msft

I will try that, thank you!