Create a Slicer that will filter across multiple columns

Anonymous — Wed, 06 Nov 2019 22:21:47 GMT

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?

Re: Create a Slicer that will filter across multiple columns

Greg_Deckler — Thu, 07 Nov 2019 02:56:47 GMT

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

...

topic Re: Create a Slicer that will filter across multiple columns in DAX Commands and Tips

Create a Slicer that will filter across multiple columns

Re: Create a Slicer that will filter across multiple columns