Create a Slicer that will filter across multiple columns

[Anonymous]

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?

[Greg_Deckler · Accepted solution]

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

...