| Catching Multiple Slicer Selections in a Formula |
| Written by Rob Collie |
| Thursday, 08 September 2011 21:39 |
|
A long time ago I did a post on using slicer selections in Excel formulas. That technique only worked when you select single values on slicers, though - any more than one and the dreaded "(Multiple items)" foils your well-laid plans. How to handle that multi-select case became a very common question - in email and posted as comments. Read more... |
Author articles
- The Dreaded "One to One" Relationship, or Why "Boaring" Movies Are Best
- "Relationship may be needed?" But I already have a relationship! What's going on?
- Pareto Analysis the Easy Way
- Adding a Minimum Threshold Slicer to "Stores That went negative" Technique
- Showing Only Months/Weeks/Etc. When at Least N Stores Showed a Certain Behavior
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
