It’s Actually VERY Simple to Catch Users’ Slicer Selections in Excel Formulas,
IF You Are Using PowerPivot (AKA the 2013 Data Model Feature)
A Popular Topic
No, I don’t mean things like “Fox Urine” or “Face to Anogenitaled” – those are pretty funny of course, and they come up in my job because I consult for my scientist neighbor on his lab rat projects.
But no, I’m here to talk about something even more popular than Fox Urine
Every day, one of the most-read topics on this blog is some variant of “I want to catch slicer selections in formulas.” This has been covered in at least three different posts:
There have also been a number of comments on each post that suggested alternate (and often better) ways of doing things. I’ve never been terribly comfortable with that third post in particular, the one dealing with multiple selections.
Funny thing is, I used a new technique (for me) in the Calendar Chart posts, but never went back and called it out explicitly. Today I am going to correct that omission.