Class Eleven; Text ( Building Dashboard with a Slicer )

A slicer is a visualization tool that allows you to filter and manipulate data in a dashboard. Slicers are often used in conjunction with PivotTables and Pivot Charts. They’re essentially interactive filters that allow you to quickly narrow down the data in a dashboard to just the information you need. For example, if you have a PivotTable showing sales data for all of your products, you could use a slicer to just show the data for a specific product category. 

Creating a slicer

Click on any of your visuals and go to insert and click slicer icon, it will give options of list of items to create a slicer for, select the items you want to create slicers with e.g products, year and region, go to slicer setting and format it to the color of your choice.

Right click all the slicer and click report connection and tick all pivot table to link all the visuals together.