How to get multi value from dropdown list that i created?

[Kruz]

i created slicer and set some value in dropdown list and try to get it to be filter on my visual.

but the problem is when i selected 1 option it showed result correctly.

but once i selected more than 1 or even select “Selected All” it showed me “No Result!”

i thought it might because i didnt set my code to be flexible enough…. but after i changed, it still no result

Dose any one know what is the structure or syntax for dropdown to get muli data?

[dwhitemv]

If Major is a Text filter with Multiple select, it’s replaced with text like one, two, three. You can’t use it outside of a IN () predicate. The {{Major}} IS NULL part is not valid.