Quick Explore Button

%3CLINGO-SUB%20id%3D%22lingo-sub-3288796%22%20slang%3D%22en-US%22%3EQuick%20Explore%20Button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288796%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Quick%20Explore%20Button%20does%20not%20come%20up%20in%20my%20PivotTables%20and%20PivotCharts.%20I%20have%20a%20school%20project%20due%20and%20am%20at%20a%20loss%20as%20to%20how%20to%20make%20this%20feature%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3288796%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3317461%22%20slang%3D%22en-US%22%3ERe%3A%20Quick%20Explore%20Button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3317461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1366704%22%20target%3D%22_blank%22%3E%40AKFlys%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20students%20with%20the%20same%20problem.%20I%20believe%20it%20may%20be%20the%20version%20of%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20do%20a%20workaround%20by%20clicking%20on%20the%20Item%20and%20selecting%20%22Drill%20Down%22%20from%20the%20PivotChart%20Analyze%20tab.%20If%20you%20need%20to%20drill%20down%2C%20this%20will%20do%20the%20same%20thing.%20It%20is%20just%20a%20bit%20of%20work.%26nbsp%3B%20If%20you%20are%20changing%20how%20you%20filter%2C%20you%20can%20always%20go%20to%20the%20worksheet%20that%20includes%20your%20PivotTable%20to%20adjust%20your%20PivotTable%20Fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20our%20textbook%20Field%20List%20settings%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LoriO300_0-1651704273725.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369325i65A58FE4FB2FBC1A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LoriO300_0-1651704273725.png%22%20alt%3D%22LoriO300_0-1651704273725.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20another%20sheet%2C%20the%20following%20PivotChart%20will%20update%20to%20the%20following%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LoriO300_1-1651704360501.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369326i3225604D8CBCBB29%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LoriO300_1-1651704360501.png%22%20alt%3D%22LoriO300_1-1651704360501.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

The Quick Explore Button does not come up in my PivotTables and PivotCharts. I have a school project due and am at a loss as to how to make this feature work.

1 Reply

@AKFlys 

I had students with the same problem. I believe it may be the version of 365.

 

You can do a workaround by clicking on the Item and selecting "Drill Down" from the PivotChart Analyze tab. If you need to drill down, this will do the same thing. It is just a bit of work.  If you are changing how you filter, you can always go to the worksheet that includes your PivotTable to adjust your PivotTable Fields.

 

This is our textbook Field List settings:

LoriO300_0-1651704273725.png

 

On another sheet, the following PivotChart will update to the following:

LoriO300_1-1651704360501.png