Slicer Single Select and Select All option at same time?

[wiselyman3]

I'm working on a dashboard tracking employee metrics, and want to be able to have a tile slicer that shows All employees and their average for some metrics, and then drill down to filter by department. Ideally I'd like to have a slicer that has the options of "All Employees", "Operations", Human Resources", "Finance", with only one being able to be selected at a time. In order to show company wide metric visuals as well as department specific metrics only having to click once. Currently it doesnt seem like this is an option. 

[Anonymous · Accepted solution]

Hi @wiselyman3 ,

Yes, it is possible. Field parameters could help you. Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. Please refer to

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.