Dropdown Slicer filtering based on another slicer (same table)

[law_90]

Hi all,

I am new to Power BI and to speed up my dashboard progress, I decided to ask some question here for assistance.

I have the below 2 slicers in my dashboard namely Owner and Manager, their source are from the same table but different column.

My question is how can I make the Manager drop down slicer to automatically display the Manager value for the respective Owner?

As you can see above, it is currently display as All when I select Automation_COE.

I would like the end result be like the below:
When I select Automation_COE as the owner, the Manager slicer will automatically display the Manager for the Owner instead of showing the All value.

Thank you for your help!