Forum Discussion
Advocate IMake a slicer exclusive
Hello,
My data is sensitive and can't be filtered more than once. So I would like to make the following :
If the user uses one of the slicers, then he can't use the other ones (they'd become disabled or something)
For instance, on my screenshot, if I use the slicer A, I'm not able to use of the slicers B. Inversely, if I use one of the slicers B, then I can't use the slicer A.
How to do this please ? I didn't find the way ! Thanks a lot !
Hi Jackisover
Here are the snapshot of how I did this as below:
When I select country Bahrain and after that I selected year 2015 than I got blank value.
So, I created one measure which will be used for cascading.
After that I apply that measure on visual filter and in that I select advance filtering and from dropdown select "is" and write "1" in the space and then apply filter.
Thus, after applying cascading, when I select Bahrain country from the slicer, it will filter out the year which returns the value balnk.
You can aslo apply the same cascading on country slicer also. In that country slicer will get filtered if the user first select the year slicer.
Best Regards.If my solution helps you than please accept it as solution.
Thanking you!
9 Replies
Hi Jackisover ,
I think you can use Bookmarks, it can help you where Slicer A is visible and Slicer B is hidden, and another one where Slicer B is visible and Slicer A is hidden.
Then I create a table and two slicers as you mentioned.
Then I create two bookmarks.
You can hide the bookmarks you do not want to select.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JackisoverThank you Anonymous
It could be a solution, yes. But I think it's a complicated procedure while I already use 15 bookmars in this same page. I was hoping for something more obvious that I wouldn't know
Hi Jackisover
The one way is you can make the slicer related to each other.
Like if slicer A is selected then slicer B will filter itself with the data which give some value and vice versa.Thus, you can make use of cascading.
Best Regards.
- Jackisover
Thanks but how can I do that ?
Hi Jackisover
If there any chance you can share sample data so I'll directly show you cascading on that related data or it will be okay if I give you idea of cascading using any other data.
Best Regards.