Forum Discussion
v-buylma
7 years agoMicrosoft Employee
Slicer selected with one fixed AND one optional values
Hi everyone,
I have a list of events, which are grouped by the departments. However, some events are interesting for all departments (=cross dept.). In the slicer I have each departmant and cross dept. How can I have the "cross dept." always selected and additionaly any selection of users, so that they can see the events of their departments and also the cross department events.
Thanks for any help and suggestion.
BY
1 Reply
- Greg_DecklerCommunity Champion
Perhaps try using a hidden slicer or a page level filter. Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490