Main Button to Filter Everything


  • Goal:
    Make a clear filter of everything and return to the standard list in the pivot table by pressing a main button. The button clear everything of what you have made some selection among slicer in PowerPivot in Excel 2010.

    There is no main button to do it. How should I get it?

    The excel document has a pivot table that is connected to a powerpivot. In addtion I have three slicer with different selection. Each slicer has a small filter functionality. In my case, I want a main button to press it instead of pressing totally three times from slicers.

    • Edited by Sakura Data Wednesday, June 12, 2013 6:26 PM
    Wednesday, June 12, 2013 6:25 PM


  • There's a "Clear Filters" menu item for that. 

    With the pivot table selected, PivotTable Tools -> Options tab in the Ribbon -> Clear -> Clear Filters

    Could also record a macro and hook it up to a button if you don't want to deal with clicking through the ribbon / tab.

    Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts //

    Thursday, June 13, 2013 8:18 PM