We help IT Professionals succeed at work.
Get Started

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

394 Views
1 Endorsement
Last Modified: 2016-02-11
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
Microsoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE