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

Can you share a sample of the table? It can be replaced/dummy data but I just want to get an accurate picture of its current state

Danielwood's avatar
Danielwood
Helper I
2 years ago

Hi, sorry for slow reply. I've not been able to load dummy data, but here is an example of what it would look like

AssetKeyboardscreenmouse
laptopYNN
pcYYY
macYYN
switchNYN

 

So if i selected a filter on Keyboard = Y i would expect the 3 returns. If i selected keyboard and screen, currently i would only see PC and MAC, assuming i selected the Kayboard slicer first.

 

But what i would actually want to see is a list of all 4 items.

 

Does that make sense?

  • ray_aramburo's avatar
    ray_aramburo
    Super User
    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.