Forum Discussion
Filter slicer based on the another slicer
I want to know that there is any way using which i can filter the slicer records based on the another slicer value selection. Eg. I want to keep the selection of vegetable,fruits and on the bas...
Hi Moulick,
In your scenario, firstly, please create another link table as follows.
Secondly, create relationship between the link table and Table 2.
Thirdly, create slicers using relevant columns. For more details, please review the example in this attached PBIX file.
Thanks,
Lydia Zhang
It works only if you are using 2 slicers in a report, It doesn't work if you display some other data along with this in another visuals.