Business analysis glossary
Slicer
What it is
A slicer is an on screen filter in Power BI or Excel that lets report users choose values, such as a date range, region or product, and instantly filter the visuals on the page. Slicers can be single or multiple choice and can be linked to several visuals.
Why it matters
Slicers turn a static report into a tool people can explore themselves, which reduces requests for slightly different versions of the same report. Analysts decide which slicers users need from the questions they ask, and make sure the measures still give correct results under every filter.
Example
In the returns dashboard, the analyst adds slicers for month, warehouse and return reason. The operations head selects one warehouse and the reason damaged item, and immediately sees that damage returns spiked after a packaging supplier changed. That insight would have needed a new report request before.