Forum Discussion
Problem with Drill-down pivot table
Hello Jan Karel,
how can I attach files or send a link here in this discussion? My posts always get deleted or blocked automatically, when I try to add a document or a link to my post.
Sorry about that. Our system has an automatic spam filter. Every weekday, our team manually goes through the spam quarantine and moves messages out of it that don't belong. I've unmarked your posts as spam.
Feel free to delete any extraneous/repeat posts as I wasn't sure which was the one that best represented what you wanted to say.
- Does the workaround above not work for you Mielkew ?
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
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
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
- Thanks for jumping in Wyn.
- My Excel version is newer: version 1808, bld 10730.20053 (click to run)
Very interesting, when I make a double click on "I2" in sheet "Table loaded in PowerPivot" I get 12 records. From sheet "Table direct Pivot" I get correctly 3 records back.
Is my Excel / PowerPivot broken? My colleagues have the same issue.
I have this Excel Version (2016) and Build:- If I DL your example file and double-click cell I2 on either worksheet, I get a new worksheet inserted (as expected). Both new worksheets contain the same three records:
ID Provider Shipper Country Consignee Country Weight
18 TNT CN DE 67.7
17 DHL CN DE 10.1
4 UPS DE DE 27.8 - Hello Jan Karel,
this workaround won't help. I've added all slicers to the page filter. The result of the drill down is still wrong, when the data source is coming from Power Pivot. - Now I understand. This is a known issue with pivot tables in Excel: If a slicer filters your data busing a field which is NOT in the pivottable anywhere, the filter on that field is not used in the drill-down. The work-around is to add the slicer field to the pivot table, for example as a page filter.
