Dropdown Slicer filtering based on another slicer (same table)

law_90 — Mon, 16 Jan 2023 07:57:31 GMT

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!

topic Dropdown Slicer filtering based on another slicer (same table) in Custom Visuals Development Discussion

Dropdown Slicer filtering based on another slicer (same table)