Slicers - If Column Record Contains

[jkancler]

I have a column called "Tags" with multiple tags in the same field separated by a comma. For example:

[Column Name] Tags
[Record Value] All Keywords, Head Terms, Potpourri, Flameless Fragrance

There are over 20 different tag values. I need to be able to create a slicer that looks at the Tags column and filter the data by each comma separated value. Would appreciate some pointers in how to accomplish this task.

Thanks!

 

[scottsen]

I think you are going to have to break out that comma separated list into 1 row per "tag value" / "record value". If those are the values you want on the slicers.... no other way.