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.