How to Create Cascading Slicers with multiple Table Relation

Thank you for the replay, I'm honestly new to Power Bi and I'm still learning new things everyday 😄

I still have no idea how to do that, so maybe if I explain it like this: so for every Sector it has multiple Agencies, and for every Agency it has multiple Departments. So what I want to do is create 3 slicers first one for Sectors and I want it to filter Agency slicer, then Agency slicer filters Department Slicer.

After doing that I want all slicers to filter my Data tables which are (Training - OverTime - Emp info).

What I did in the picture is link Sector to all data tables from Sectors Table, then link Agency to all data tables from Agencies table, then link Department from Departments table. Some of them were first two were linked without a problem but the last one gives me "Ambiguous path" Error. I which I can upload the file, it contains dummy data that just explains what I need.