Overview
When attempting to drill-down on a measure you may receive the following message:
"Show Details cannot be executed when multiple items are selected in a report filter field or in a slicer. Select a single item for each field in the report filter area and for each slicer connected to this PivotTable before performing a drill through."
Cause:
Microsoft Analysis Services does not support the drill-down feature if multiple filter items are selected in the filter field. This error occurs when you have a dimension level or hierarchy in the filter section of the pivot table which is filtering on multiple items.
Resolution
For example: Let's say we want to filter on dates to only show data in 2013 and 2014.
Notice how the filter condition is checked to Select Multiple Items. When multiple items are selected, you lose the ability to drill-down on individual metrics. To resolve you must either:
-
Select a single item (for example, 2014)
-
Select all items (deselect the box)
Comments