How can I show the results of one slicer at a time?

[Anonymous]

I have three slicers (in green) and I want to show the results of only one of them in the (blue) table at a time. 

The problem is that the table always shows one slicer's results - who.

All the sclicers should have the same data - that is year. So, the value that I assigned to the table is a shared column between the slicers. But the problem is that it only whows one slicer's results and then it stops.

I even tried to add "Select All" to each slicers. So, one can set two slciers to all, and chose from the thors slicer. That did not work either. 

Any ideas are welcome!

Thanks!

[v-jayw-msft]

Hi @Anonymous ,

Are they from same table?

If so you will need to create 3 independent slicer tables so that they won't impact each other.

Please share the data model if you need further help.

Best Regards,

Jay

[Arul]

@Anonymous ,

Can you share your sample data?