Slicers and filters are what turn a static report into an interactive dashboard. This chapter covers the difference between slicers (visible, viewer-controlled) and the Filters pane (hidden, developer-controlled), the four main slicer styles (list, dropdown, between, and relative date), and how to sync slicers across multiple report pages so a single selection updates the entire dashboard.

You add a Year slicer to the Charts page and select 2024. The visuals on the Charts page update, but the KPIs page is unaffected. What do you need to do?

Master the skills needed to turn raw data into professional, interactive reports using Power BI. You'll connect to data sources, clean and transform data with Power Query, build data models, write DAX measures, and publish polished dashboards to Power BI Service. No prior experience required.

Slicers and Filters