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

-Polak
-Polak used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Microsoft Excel Expert
Top Expert 2014
Commented:
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.

Author

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 Expert
Top Expert 2014

Commented:
Thanks for the feedback.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial