Problem with Drill-down pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-173121%22%20slang%3D%22en-US%22%3EProblem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173121%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%26nbsp%3Bthree%26nbsp%3Bpivot%20tables%20with%20several%20slicers%20connected%20to%20each%20of%20the%20tables.%3C%2FP%3E%0A%3CP%3EWhen%20I%20drill%20down%20to%20details%20in%20anyone%20of%20the%20tables%20it%20doesn't%20always%20reflect%20the%20filters%20from%20the%20slicers.%3C%2FP%3E%0A%3CP%3EIt%20seems%20that%20if%20one%20single%20value%20is%20filtered%20from%20one%20slicer%2C%20the%20details%20still%20include%20all%20the%26nbsp%3Bdata%20from%20that%20slicers%20values.%20If%20two%20or%20more%20values%20is%20filtered%20in%20the%20slicer%2C%20the%20drill%20down%20seems%20to%20include%20the%20correct%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20discussed%20work-around%20of%20adding%20an%20actual%20filter%20to%20the%20pivot%20tables%20doesn't%20solve%20the%20problem%2C%20also%20that%20bug%20should%20be%20solved%20in%20Excel%202016%2C%20which%20is%20the%20version%20I%20use.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20pivot%20tables%20are%20based%20on%20data%20from%20PowerPivot%20(excel%20table)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAny%20suggestions%20on%20how%20to%20address%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBest%20regards%3C%2FP%3E%0A%3CP%3EFredrik%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-173121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241380%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241380%22%20slang%3D%22en-US%22%3E%3CP%3ESounds%20like%20an%20old%20bug%20that%20should%20have%20been%20fixed%20but%20clearly%20isn't%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcontexturesblog.com%2Farchives%2F2012%2F03%2F22%2Fdrill-to-detail-with-excel-slicer-filters%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcontexturesblog.com%2Farchives%2F2012%2F03%2F22%2Fdrill-to-detail-with-excel-slicer-filters%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20workaround%20sounds%20like%20you%20also%20add%20the%20filters%20in%20your%20slicers%20to%20your%20filter%20pane%20of%20your%20pivot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20great%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241379%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241379%22%20slang%3D%22en-US%22%3E%3CP%3ESounds%20like%20an%20old%20bug%20that%20should%20have%20been%20fixed%20but%20clearly%20isn't%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcontexturesblog.com%2Farchives%2F2012%2F03%2F22%2Fdrill-to-detail-with-excel-slicer-filters%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcontexturesblog.com%2Farchives%2F2012%2F03%2F22%2Fdrill-to-detail-with-excel-slicer-filters%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20workaround%20sounds%20like%20you%20also%20add%20the%20filters%20in%20your%20slicers%20to%20your%20filter%20pane%20of%20your%20pivot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20great%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241368%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241368%22%20slang%3D%22en-US%22%3EThanks%20for%20jumping%20in%20Wyn.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241106%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241106%22%20slang%3D%22en-US%22%3E%3CP%3EI%20get%20the%20same%20result%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%2C%26nbsp%3B%20%26nbsp%3B3%20records%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EReally%20odd%20getting%2012%20results%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CHR%20%2F%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240811%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240811%22%20slang%3D%22en-US%22%3EMy%20Excel%20version%20is%20newer%3A%20version%201808%2C%20bld%2010730.20053%20(click%20to%20run)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240772%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240772%22%20slang%3D%22en-US%22%3E%3CP%3EVery%20interesting%2C%20when%20I%20make%20a%20double%20click%20on%20%22I2%22%20in%20sheet%20%22Table%20loaded%20in%20PowerPivot%22%20I%20get%2012%20records.%20From%20sheet%20%22Table%20direct%20Pivot%22%20I%20get%20correctly%203%20records%20back.%3CBR%20%2F%3EIs%20my%20Excel%20%2F%20PowerPivot%20broken%3F%20My%20colleagues%20have%20the%20same%20issue.%3CBR%20%2F%3EI%20have%20this%20Excel%20Version%20(2016)%20and%20Build%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20389px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44609i737ED46DFC211D58%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240765%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240765%22%20slang%3D%22en-US%22%3EIf%20I%20DL%20your%20example%20file%20and%20double-click%20cell%20I2%20on%20either%20worksheet%2C%20I%20get%20a%20new%20worksheet%20inserted%20(as%20expected).%20Both%20new%20worksheets%20contain%20the%20same%20three%20records%3A%3CBR%20%2F%3EID%20Provider%20Shipper%20Country%20Consignee%20Country%20Weight%3CBR%20%2F%3E18%20TNT%20CN%20DE%2067.7%3CBR%20%2F%3E17%20DHL%20CN%20DE%2010.1%3CBR%20%2F%3E4%20UPS%20DE%20DE%2027.8%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240761%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240761%22%20slang%3D%22en-US%22%3EHello%20Jan%20Karel%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ethis%20workaround%20won't%20help.%20I've%20added%20all%20slicers%20to%20the%20page%20filter.%20The%20result%20of%20the%20drill%20down%20is%20still%20wrong%2C%20when%20the%20data%20source%20is%20coming%20from%20Power%20Pivot.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240740%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240740%22%20slang%3D%22en-US%22%3ENow%20I%20understand.%20This%20is%20a%20known%20issue%20with%20pivot%20tables%20in%20Excel%3A%20If%20a%20slicer%20filters%20your%20data%20busing%20a%20field%20which%20is%20NOT%20in%20the%20pivottable%20anywhere%2C%20the%20filter%20on%20that%20field%20is%20not%20used%20in%20the%20drill-down.%20The%20work-around%20is%20to%20add%20the%20slicer%20field%20to%20the%20pivot%20table%2C%20for%20example%20as%20a%20page%20filter.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240174%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240174%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20about%20that.%20Our%20system%20has%20an%20automatic%20spam%20filter.%20Every%20weekday%2C%20our%20team%20manually%20goes%20through%20the%20spam%20quarantine%20and%20moves%20messages%20out%20of%20it%20that%20don't%20belong.%20I've%20unmarked%20your%20posts%20as%20spam.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFeel%20free%20to%20delete%20any%20extraneous%2Frepeat%20posts%20as%20I%20wasn't%20sure%20which%20was%20the%20one%20that%20best%20represented%20what%20you%20wanted%20to%20say.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239838%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239838%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Jan%20Karel%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20can%20I%20attach%20files%20or%20send%20a%20link%20here%20in%20this%20discussion%3F%20My%20posts%20always%20get%20deleted%20or%20blocked%20automatically%2C%20when%20I%20try%20to%20add%20a%20document%20or%20a%20link%20to%20my%20post.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239825%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239825%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Jan%20Karel%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20add%20an%20attachment.%20It's%20always%20marked%20as%20spam.%20Very%20strange.%3C%2FP%3E%3CP%3ESo%20here%20is%20a%20link%20to%20an%20example%20file%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D0B26mQbliZPiyakFpVEoyQUtWR0Z1QjBZLW5DWmFLQklkSThB%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EGoogle%20Drive%20Link%20to%20Example%20File%3C%2FA%3E%3C%2FP%3E%3CP%3EI've%20created%20two%20worksheets.%20One%20uses%20PowerPivot%2C%20the%20other%20one%20gets%20the%20data%20directly%20from%20the%20worksheet.%20I've%20also%20already%20set%20the%20filters.%20Try%20a%20drill%20down%20in%20both%20sheets.%20You%20will%20see%20different%20results.%20The%20one%20from%20the%20data%20model%20in%20PowerPivot%20will%20return%20a%20wrong%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EVirty%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239820%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239820%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Jan%20Karel%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20find%20attached%20an%20example.%20I've%20created%20two%20worksheets.%20One%20uses%20PowerPivot%2C%20the%20other%20one%20gets%20the%20data%20directly%20from%20the%20worksheet.%20I've%20also%20already%20set%20the%20filters.%20Try%20a%20drill%20down%20in%20both%20sheets.%20You%20will%20see%20different%20results.%20The%20one%20from%20the%20data%20model%20in%20PowerPivot%20will%20return%20a%20wrong%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EVirty%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239796%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239796%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Jan%20Karel%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20find%20attached%20an%20example%20file.%3C%2FP%3E%3CP%3EI've%20created%20two%20sheets%20(once%20the%20data%20is%20stored%20in%20Power%20Pivot%20and%20the%20other%20one%20catches%20the%20data%20directly%20from%20the%20work%20sheet)%20and%20I've%20set%20already%20the%20filters%20in%20the%20data%20slicer.%20Make%20a%20drill%20down%20and%20you%20will%20see%2C%20that%20you%20will%20get%20two%20different%20results.%20The%20one%20from%20PowerPivot%20will%20give%20you%20the%20wrong%20number%20of%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EVirty%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239787%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239787%22%20slang%3D%22en-US%22%3EI%20would%20need%20your%20workbook%20to%20try%20and%20figure%20out%20what%20the%20problem%20is.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239367%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239367%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Jan%20Karel%2C%3C%2FP%3E%3CP%3EI%20have%20tried%20what%20you've%20said%20and%20it's%20still%20not%20working.%20I%20still%20get%20the%20wrong%20amount%20of%20results%20back%20when%20I%20drill%20down%20having%20multiple%20selections%20within%20one%20or%20more%20data%20slicers%20and%20in%26nbsp%3Bone%20data%20slicer%20only%20one%20selection.%20So%20it's%20not%20a%20design%20problem.%20Seems%20to%20be%20a%20real%20bug.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20to%20make%20it%20clear%3A%3C%2FP%3E%3CP%3EI%20set%20select%20one%20item%20in%20any%2Fall%20data%20slicers%20--%26gt%3B%20No%20problem.%3C%2FP%3E%3CP%3EI%20select%202%20or%20more%20items%20in%20any%2Fall%20data%20slicers%20--%26gt%3B%20No%20problem.%3C%2FP%3E%3CP%3EI%20select%202%20or%20more%20items%20in%20any%20data%20slicers%2C%20but%20in%20one%20data%20slicer%20I%20select%20only%201%20item%20--%26gt%3B%20Wrong%20amount%20of%20data%20sets%20in%20the%20drill%20down!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EVirty%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239348%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239348%22%20slang%3D%22en-US%22%3EI'm%20pretty%20sure%20this%20is%20not%20a%20bug%20but%20rather%20a%20design%20problem%20in%20your%20model.%20FIlters%20MUST%20be%20set%20on%20fields%20containing%20JUST%20the%20filter%20values.%20For%20example%3A%20Suppose%20your%20data%20contains%20a%20column%20with%20(possibly%20repeating)%20date%20values.%20You%20should%20never%20filter%20your%20pivots%20on%20that%20column%20(field).%20Instead%2C%20you%20should%20be%20adding%20a%20date%20table%20which%20contains%20all%20dates%20(NO%20DUPLICATES!)%20you%20have%20in%20your%20model%2C%20create%20a%20link%20between%20the%20date%20and%20the%20data%20table%20and%20then%20filter%20your%20model%20using%20the%20date%20field%20of%20the%20dates%20table.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239340%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239340%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Fredrik%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20your%20fast%20reply.%3C%2FP%3E%3CP%3EI%20am%20also%20sure%2C%20that%20this%20must%20be%20a%20bug.%3C%2FP%3E%3CP%3EIt's%20a%20pity%20that%20I%20have%20to%20create%20my%20dashboard%20based%20on%20a%20regular%20worksheet%20now.%20It%26nbsp%3Bincreases%20the%20file%20size%20by%20several%20times%20and%20also%20my%20measures%20don't%20work%20anymore%2C%20so%20I%20have%20to%20use%20some%20work-arounds%20based%20on%20normal%20pivot%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EVirty%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239326%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239326%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Virty%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%2C%20I%20gave%20up%20and%20created%20the%20same%20dashboard%20with%20pivottables%20and%20slicers%20from%20a%20regular%20Excel%20table%20instead.%20For%20my%20needs%20it%20wasn%C2%B4t%20really%20necessary%20with%20a%20Powerpivot%20table%20I%20only%20wanted%20the%20option%20to%20create%20measures%20in%20an%20easier%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20really%20looks%20a%20bug%20to%20me%20too%2C%20at%20least%20I%20haven%C2%B4t%20found%20any%20good%20reason%20why%20this%20functionality%20would%20differ%20Power%20Pivot%20models%2Fregular%20excel%20tables.%20Because%20one%20thing%20is%20clear%2C%20it%20does%20differ.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EFredrik%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239290%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239290%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Fredrik%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehave%20you%20found%20a%20solution%20yet%3F%3C%2FP%3E%3CP%3EI%20am%20facing%20the%20same%20problem.%3C%2FP%3E%3CP%3EI've%20created%20a%20dashboard%20with%20many%20data%20slicers%20and%20an%20option%20to%20drill%20down%20the%20filtered%20data.%3C%2FP%3E%3CP%3EIf%20there%20is%20a%20data%20slicer%20with%20multiple%20selections%20and%20any%20other%20data%20slicers%20with%20at%20least%20one%20filter%2C%20then%20the%20drill%20down%20(%22show%20details%22%20%2F%20data%20extract)%20won't%20show%20the%20correct%20number%20of%20entries.%20Some%20data%20slicers%20will%20be%20just%20ignored.%20It's%20very%20confusing.%3C%2FP%3E%3CP%3EThis%20only%20happens%20when%20the%20data%20comes%20from%20the%20power%20pivot%20data%20model.%20I've%20created%20the%20same%20dashboard%20having%20the%20complete%20data%20in%20a%20work%20sheet.%20There%20it%20works%20without%20any%20problems.%20I%20only%20get%20the%20filtered%20data%20back%20when%20I%20drill%20down%2C%20no%20matter%20how%20I%20set%20the%20data%20slicers.%3C%2FP%3E%3CP%3EThis%20seems%20to%20be%20a%20bug%20to%20me.%20In%20Excel%202013%20it%20wasn't%20possible%20to%20select%20multiple%20values%20within%20a%20data%20slicer%20and%20afterwards%20to%20drill%20down.%20Finally%20it%20works%20in%20Excel%202016%2C%20but%20it's%20a%20really%20weird%20bug%2C%20that%20it%20doesn't%20work%20correctly%20when%20the%20data%20comes%20from%20the%20Power%20Pivot%20data%20model.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EVirty%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174051%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174051%22%20slang%3D%22en-US%22%3EI%20strongly%20suspect%20there%20are%20some%20design%20flaws%20in%20your%20powerpivot%20model.%20Filtering%20yielding%20unexpected%20results%20is%20usually%20a%20clear%20indication%20something%20is%20wrong%20with%20the%20model.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174026%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174026%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20really%20been%20struggling%20with%20this%20for%20days%20now.%20Selecting%20single%20values%20from%20slicers%20works%20fine%20(besides%20the%20result%20will%20include%20records%20for%20both%20measures%20even%20if%20I%20only%20drill%20on%20one%20of%20them).%20Selecting%20one%20value%20from%20one%20slicer%20AND%20multiple%20values%20from%20another%20slicer%20give%20an%20incorrect%20result.%20Multiple%20values%20from%20multiple%20slicers%20also%20return%20correct%20result.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20thought%20maybe%20it%20had%20something%20to%20do%20with%20drilling%20on%20created%20measures%20from%20PowerPivot%20but%20then%20You%20wouldn't%20get%20different%20(correct)%20results.%20It%20seems%20it%20has%20something%20to%20do%20with%20my%20settings%20in%20excel%20or%20other%20local%20settings.%20But%20I%20can't%20think%20of%20what%20that%20could%20be%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20really%20confusing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-173921%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173921%22%20slang%3D%22en-US%22%3E%3CP%3EOk%20good%20someone's%20getting%20it%20right%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%0A%3CP%3EThat's%20really%20hard%20to%20explain.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-173598%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173598%22%20slang%3D%22en-US%22%3EOdd.%20If%20I%20filter%20for%2040%2C%20I%20do%20get%20the%20expected%207%20records%2C%20filtering%20for%2042%20yields%2013%20records%20and%20filtering%20for%2040%20and%2042%20gives%20precisely%2020.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-173508%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173508%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYeah%20but%20that's%20the%20thing%2C%20it%20doesn%C2%B4t%20make%20any%20difference%20having%20the%20slicer%20fields%20as%20page%20filters.%3C%2FP%3E%0A%3CP%3EAttach%20an%20example%20of%20the%20workbook%20for%20clarification%2C%20see%20sheets%20Case%201a%20%26amp%3B%20b.%20Produce%20the%20same%20results%20with%20different%20filters.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMaybe%20it%20has%20something%20to%20do%20with%20my%20created%20measures%20in%20Powerpivot%20but%20can't%20figure%20out%20what%20could%20be%20wrong%20there%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBR%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFredrik%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-173280%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173280%22%20slang%3D%22en-US%22%3EThis%20is%20%22by%20design%22.%20If%20you%20have%20a%20slicer%20tied%20to%20a%20field%20that%20isn't%20used%20anywhere%20in%20the%20pivottable%2C%20the%20slicer%20filter%20is%20ignored%20during%20drill-down.%20Add%20the%20slicer's%20field%20to%20the%20page%20filter%20area%20and%20it%20should%20work%20as%20expected.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-920264%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-920264%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20issue%20has%20this%20been%20resolve%3F%20Anyone%20can%20share%20input%20how%20to%20overcome%20this%20in%20PowerPivot%3F%20Appreciate%20any%20input%20from%20you%20guys%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-921091%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Drill-down%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-921091%22%20slang%3D%22en-US%22%3EDoes%20the%20workaround%20above%20not%20work%20for%20you%20Mielkew%20%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

It seems that if one single value is filtered from one slicer, the details still include all the data from that slicers values. If two or more values is filtered in the slicer, the drill down seems to include the correct data.

 

The discussed work-around of adding an actual filter to the pivot tables doesn't solve the problem, also that bug should be solved in Excel 2016, which is the version I use.

 

The pivot tables are based on data from PowerPivot (excel table)

 

Any suggestions on how to address this?

 

Best regards

Fredrik

28 Replies
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

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:

 

image.png

My Excel version is newer: version 1808, bld 10730.20053 (click to run)

I get the same result as @Jan Karel Pieterse,   3 records   

 

Really odd getting 12 results

 


 

Thanks for jumping in Wyn.

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 

 

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 

Does the workaround above not work for you Mielkew ?