We help IT Professionals succeed at work.
Get Started
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.
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.
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