Forum Discussion
Fredrik Nilsson
Mar 19, 2018Copper Contributor
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....
Wyn Hopkins
Sep 01, 2018MVP
JKPieterse
Sep 03, 2018Silver Contributor
Thanks for jumping in Wyn.
- Wyn HopkinsOct 21, 2019MVPDoes the workaround above not work for you Mielkew ?
- MielkewOct 20, 2019Copper Contributor
I have the same issue has this been resolve? Anyone can share input how to overcome this in PowerPivot? Appreciate any input from you guys Wyn Hopkins
- Wyn HopkinsSep 03, 2018MVP
Sounds like an old bug that should have been fixed but clearly isn't
https://contexturesblog.com/archives/2012/03/22/drill-to-detail-with-excel-slicer-filters/
The workaround sounds like you also add the filters in your slicers to your filter pane of your pivot.
Not great
- Wyn HopkinsSep 03, 2018MVP
Sounds like an old bug that should have been fixed but clearly isn't
https://contexturesblog.com/archives/2012/03/22/drill-to-detail-with-excel-slicer-filters/
The workaround sounds like you also add the filters in your slicers to your filter pane of your pivot.
Not great