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....
JKPieterse
Aug 31, 2018Silver Contributor
My Excel version is newer: version 1808, bld 10730.20053 (click to run)
Wyn Hopkins
Sep 01, 2018MVP
- 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
- JKPieterseSep 03, 2018Silver ContributorThanks for jumping in Wyn.