Forum Discussion

Fredrik Nilsson

Copper Contributor

Mar 19, 2018

Problem with Drill-down pivot table

Hi I have three pivot tables with several slicers connected to each of the tables. When I drill down to details in anyone of the tables it doesn't always reflect the filters from the slicers....

Fredrik Nilsson

Copper Contributor

Mar 20, 2018

Hello

Yeah but that's the thing, it doesn´t make any difference having the slicer fields as page filters.

Attach an example of the workbook for clarification, see sheets Case 1a & b. Produce the same results with different filters.

Maybe it has something to do with my created measures in Powerpivot but can't figure out what could be wrong there

BR

Fredrik

Pivot drill down.xlsx530 KB

Silver Contributor

Mar 20, 2018

Odd. If I filter for 40, I do get the expected 7 records, filtering for 42 yields 13 records and filtering for 40 and 42 gives precisely 20.

Fredrik Nilsson
Copper Contributor
Mar 21, 2018
I've really been struggling with this for days now. Selecting single values from slicers works fine (besides the result will include records for both measures even if I only drill on one of them). Selecting one value from one slicer AND multiple values from another slicer give an incorrect result. Multiple values from multiple slicers also return correct result.

I thought maybe it had something to do with drilling on created measures from PowerPivot but then You wouldn't get different (correct) results. It seems it has something to do with my settings in excel or other local settings. But I can't think of what that could be?

This is really confusing.
- JKPieterse
  Silver Contributor
  Mar 21, 2018
  I strongly suspect there are some design flaws in your powerpivot model. Filtering yielding unexpected results is usually a clear indication something is wrong with the model.
Fredrik Nilsson
Copper Contributor
Mar 21, 2018
Ok good someone's getting it right :-)

That's really hard to explain.

Resources