Add A Slicer To The Pivot Table. Now from the Insert Slicer dialog box select the column to use as a filter in the slicer and click OK. You will notice that after creating the slicer style there is no change to the slicer.
The issue is when I create a chart from the pivot. On the PivotTable Tools Analyze tab PivotTable Tools Options tab in Excel 20072010 in the Filter group Sort Filter group in Excel 20072010 click the Insert Slicer command and then select Insert Slicer in Excel 20072010. Select the fields which we want to see in Slicer.
If you use Power Query to get the data make sure that you add the query to the workbook data model.
Well check Region and click OK. On the PivotTable Tools Analyze tab PivotTable Tools Options tab in Excel 20072010 in the Filter group Sort Filter group in Excel 20072010 click the Insert Slicer command and then select Insert Slicer in Excel 20072010. On the PivotTable Analyze tab click Insert Slicer. Insert the Slicers.
