Solved: Slice based on multiple inputs - Page 2

aerodactylgrits · 02-05-2020 12:21 AM

I want to filter my data using slices based on the user input.

I have the slice set up with the row filter conditon: ANY(Filter[Set Name]) = [Set Name]. Filter is a table with the dynamic drop down [Set Name] connected to my data. This column is set to Enumlist in the column type so I can choose more than one value.

According to the expression assistant ANY() will only return one value though, so if I choose 2 selections from my drop down I only get a return for the first value selected.

How can I choose more than 1 value from my drop down to filter accordingly?

aerodactylgrits

Solution:

AND(
if(isnotblank(Filter[Set Name]), in([Set Name], Filter[Set Name]), True),
if(isnotblank(Filter[Rarity]), in([Rarity], Filter[Rarity]), True),
if(isnotblank(Filter[Card Type]), in([Card Type], Filter[Card Type]), True),
if(isnotblank(Filter[Owned]), in([Owned], Filter[Owned]), True)
)

View solution in original post