Forum Discussion

Danielwood's avatar
Danielwood
Helper I
2 years ago
Solved

Custom filter/slicer

Hi. In my dashboard, on the first page a have a number of slicers available to users. Ideally I want to be able to use 2 slicers at once, so slicer one is Fruit name and I choose Apple, slicer 2 is B...
Need Help
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    Sorry for the delay in response, I have attached you a solution proposal if I understood your requirement correctly.

    I just unpivoted the Y/N columns to have a single one and use AND, OR options with a slicer.

ray_aramburo's avatar
ray_aramburo
Super User
2 years ago

You don't need to split the slicers in 2. Just change the setting of the slicer to turn off "Multi select with CTRL". Then select only in your slicer Apple and Banana and publish that as default or save the state of the slicer with a bookmark. 

Now, if the fruits are in different columns then it's a whole different case and my recommendation would be to change your data structure to have all of them in a single column or use a dimension table with the fruits catalog. 

Danielwood's avatar
Danielwood
Helper I
2 years ago

Hi, thanks for the response. I'm afraid this is where the problem gets a bit more complicated.

In my example above I didn't explain the live data accurately. What I have are a number of columns which are system impacts, so on row 1, across multiple columns, are different system names. Below that are simple Y or N options.

 

So on an individual basis, I have a slicer for each system. But the issue arises if I want to use a slicer that is system A or system B as an example.