Forum Discussion
Advocate IMake a slicer exclusive
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!
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.
Advocate IThanks 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.
- Jackisover
Thanks for the offer Anonymous I'm unfortunately not authorized to share this data, but any other data will work if you want to make an example. I assume cascading doesn't just mean using 2 variables in the same slicer. Thanks a lot !
Hi, Jackisover
Okay, no probelm I'll share using other data.
No cascading doesn't mean using 2 variables in the same slicer. You will have slicer according to your columns like you share in your example.I'll provide the solution soon.