SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

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.

Used in these guides

CHECK BEFORE CONTINUING

Keep your work safe