Forum Discussion

rmsl's avatar
rmsl
Frequent Visitor
3 years ago
Solved

Use specific Slicer based on selected value from another slicer

Hello Community - 

 

Thanks for your help and your thoughts - all welcomed.

 

I have two simple tables as per the below;

 

AthletesCoachPhysio
Athlete 1 Mrs C
Athlete 2Mrs DMrs C
Athlete 3 Mr B 
Athlete 4 Mr BMr E

 

ReportView
Physio
Coach

 

The BI Report has a main slicer that is based on the second table.

 

Here is what I am trying to do;

 

If I select Coach in the main slicer, I want to show another slicer based on the Coach column of the first table and filter out the blanks.

On the other end, if I select Physio in the main slicer, I want to show another slicer based on the Physio column this time - and again filtering out the blanks.

 

I could not see anything similar done anywhere else so appreciate your input here - 

 

Thanks,

R