How to enable cascading slicer filtering with separate Manager, Supervisor, Agent dimension tables?

Hi manoj_0911 , Thank you for reaching out to the Microsoft Community Forum.

Please refer attached .pbix file for reference and share your thoughts.

If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

You could try doing the following. Let's assume for simplicty that this is your model:

Arrow shows that Dim 1 and Dim 2 filter fact table -> no bidirectional filters. Fact table is linked with Dim tables like this:

• Fact -> Dim 1: Dim1Key
• Fact -> Dim 2: Dim2Key

You would like for Dim 1 selection to filter values in Dim 2 Slicer. You apply Dim 1 Slicer which filters fact table -> reduces available values of Dim2Key as well.

Based on this you could create a Measure:

Dim2Filter =
VAR FilteredKey =
VALUES ( Fact[Dim2Key] )
VAR SelectedKey =
SELECTEDVALUE ( 'Dim 2'[Dim2Key] )
RETURN
IF ( SelectedKey IN FilteredKey, 1, 0 )

Then, you can use this measure as a filter on slicer visual and select only those items where measure = 1.

Keep in mind that for large dimensions this operation can be quite heavy.