Forum Discussion
Anonymous
4 years agoNot applicable
Cascading slicers
Hi everyone I have my database on a single table, and I want to filter some value according to 2 levels (Lv1 and Lv2, let's say Factory and Sector). What I want to do is something like this: first,...
v-yanjiang-msft
4 years agoCommunity Support
Hi Anonymous ,
Sorry I didn't quite understand the problem you are facing.
In my understanding, you have factory and sector columns.
When you select Factory A in the factory slicer, the sector slicer wil show S1, S2, S3, then if you select S1 in the sector slicer, now because there's no S1 in the factory B, so factory slicer does not allow you to choose factory B.
Could you please explain more about your sample and problem?
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.