Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a Slicer that will filter across multiple columns

I need to create a filter that will allow a user to select products listed across multiple columns

 

I have a sales/fact table structured like the following:

 

DealId    Product1    Product2    Product3    Product4
   a            1                 0                 1                 0
   b            0                 1                 0                 0
   c            0                 0                 0                 1
   d            1                 1                 0                 0

 

I am trying to create a product slicer that will allow the selection of any deal where the selected product equals 1.


So far I have created a separate table with the distinct products listed in a column but I cannot figure out how to link it back to the sales table

 

I feel like the answer to this is very straightforward but I am having a hard time wrapping my head around it. Does anyone know the best way to do this?

  • Not certain I am 100% understanding the issue here but generally you would want to unpivot your Product columns so that you ended up with a table like:

     

    DealId,Product,Value

    a,Product1,1

    a,Product2,0

    a,Product3,0

    a,Product4,1

    b,Product1,0

    ...

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Not certain I am 100% understanding the issue here but generally you would want to unpivot your Product columns so that you ended up with a table like:

     

    DealId,Product,Value

    a,Product1,1

    a,Product2,0

    a,Product3,0

    a,Product4,1

    b,Product1,0

    ...