You can achieve the same with the use of parameters but the restriction we have is the single select value in parameter. With the help of filter this is not doable. I have created another solution for you but in this I included 2 sheets in dashboard with two different filter of exclude & include. May be this will help you!
Include_Exclude Filter.twbx 965.7 KB
Is there a way that you can upload a dummy data twbx?
I am using Desktop 8, and cannot open the .twbx you attached above. Is there any way you could republish it to be compatible with version 8?
Thanks so much,
2 of 2 people found this helpful
As Prashant mentioned, you could do this with a parameter of Yes/No.
The field you actually add as a quick filter is
IIF(Parameter='Yes' OR (Parameter ='No' AND Department <> 'Fine Arts'),Department,null)
You can then add this as a filter, and the Fine Arts department will become null.
You can then have a second copy of this calculated field that you use as a filter to exclude all the nulls (and don't show it to the user), and their list will just change, as well as the view.
[Note: probably would use a true/false parameter with aliases]