Javier Guillen posted on December 19, 2010 22:59
Even though you can directly reference the slicer name range in the cube formula, it won’t work if you select multiple slicer values –
But there is a trick I learned thanks to the great PowerPivotPro blog.
Going back to the sheet that holds the PowerPivot table, we had previously selected ‘Calendar Year’ as a vertical slicer. Interestingly, you can also drag and drop the same field into the report filter field, which in effect enables this field to be both a slicer and a regular filter!
By using this trick, the slicer selection will always be in sync with the pivot table filter. And in turn, we can use the regular filter cell reference in the cube formula, as they graciously understand multiple selected members in a regular filter.
After you change the cube formula, you may have to refresh the PowerPivot table, in order to override the cached values.
