Forum Discussion

Jackisover's avatar
Jackisover
Icon for Advocate I rankAdvocate I
2 years ago
Solved

Make 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 di...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Jackisover's avatar
Jackisover
Icon for Advocate I rankAdvocate I
2 years ago

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 !

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.