Single slicer for multiple values in row

Hi Anonymous ,

You can achive it by following below approach:-

1. Duplicate your table

2. Remove other two columns from duplicate table

3. Now split column by delimeter and in advance option select split into rows

4. You will see below result

5. Now remove duplicate and clikc on close & apply

6. Now add types from new duplicate table into slicer and other details from your table in table visual.

7. Create a measure for filtering your table based on selection from slicer with below code and used it as visual level filter

_Filter = 
IF (
    CONTAINSSTRING (
        MAX ( 'Beer Data'[Type] ),
        SELECTEDVALUE ( 'Beer Data_duplicate'[Type] )
    ),
    1,
    0
)

 Once you follow above steps it will work as expected:-

Thanks,

Samarth