Forum Discussion
Slicer Single Select and Select All option at same time?
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.
- Anonymous3 years ago
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.
1 Reply
- AnonymousNot applicable
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.