Excel Slicer that Utilizes Text Filters functions such as "Contains"?

Hi Experts,
I'm using an OLAP Slicer connected to PowerPivot in Excel 2013 and would like to know if there is a way to to do the following with the slicer without resorting to an ActiveX ListBox VBA Solution.

1. Have custom sliceritems in the Slicer as opposed to representing all of the unique values in the column of data
2. Have the Slicer function on the text filtering functionality of "contains"

I am trying to get around a problem where I would have to concatenate values across 6 columns of repeating data and results in some 100 possible concatenated sliceritems permutations.
LVL 1
-PolakAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Professor JMicrosoft Excel ExpertCommented:
simply put, what you are asking is Impossible to do. Slicers are tags generated. you may consider the alternative which is VBA based solution but you cannot use Slicers to put a parameter of Contain.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
-PolakAuthor Commented:
Thanks JimJam, I was hoping their might be a way to approach this using DAX in PowerPivot and some related tables, but I'm finding that to be a dead-end as well. I'll award points and let you know if I run into any trouble making an ActiveX ListBox solution.
Professor JMicrosoft Excel ExpertCommented:
Thanks for the feedback.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.