PowerPivot drill down

%3CLINGO-SUB%20id%3D%22lingo-sub-2446528%22%20slang%3D%22en-US%22%3EPowerPivot%20drill%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2446528%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20control%20how%20PP%20drills%20to%20lower%20levels%20of%20detail%3F%26nbsp%3B%20I%20would%20like%20to%20drill%20down%20one%20level%20at%20a%20time%20or%20and%20to%20select%20a%20member%20of%20a%20dimension%20and%20drill%20down%20with%20that%20member%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2446528%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2448283%22%20slang%3D%22en-US%22%3ERe%3A%20PowerPivot%20drill%20down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2448283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1078850%22%20target%3D%22_blank%22%3E%40lbohman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20that's%20not%20configurable%2C%20if%20only%20some%20workarounds%20with%20VBA%20exist.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Is there a way to control how PP drills to lower levels of detail?  I would like to drill down one level at a time or and to select a member of a dimension and drill down with that member only.

1 Reply

@lbohman 

To my knowledge that's not configurable, if only some workarounds with VBA exist.