Segmentación de Datos

%3CLINGO-SUB%20id%3D%22lingo-sub-2871795%22%20slang%3D%22es-ES%22%3EData%20Segmentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2871795%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20a%20file%20in%20which%20I%20have%20several%20slicers%20that%20connect%20different%20PivotTables%2C%20however%20I%20want%20to%20know%20how%20can%20I%20delete%20all%20the%20filters%20applied%20in%20the%20slicers%20with%20a%20single%20click%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Stephanie_Montes_0-1634852439635.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319097i42EF571AD710C973%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Stephanie_Montes_0-1634852439635.png%22%20alt%3D%22Stephanie_Montes_0-1634852439635.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EExcel%20version%3A%20Microsoft%20Office%20Home%20%26amp%3B%20Business%202019%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2871795%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Tengo un archivo en el que tengo varios segmentadores de datos que conectan distintas tablas dinámicas, sin embargo quiero saber ¿cómo puedo borrar todos los filtros aplicados en los segmentadores con un solo click?

Stephanie_Montes_0-1634852439635.png

Versión de Excel: Microsoft Office Hogar y Empresas 2019

 

1 Reply

@Stephanie_Montes 

On ribbon PivotTable Analyze -> Clear -> Clear Filters