Interactive Filtering: Slicers & Page Filters

From Static Reports to Interactive Dashboards

The goal of this lesson is to move beyond just presenting data to interacting with it. For the managers attending your workshop, this is often the "aha!" moment. Instead of requesting a new report for every question (e.g., "How did we do in the North region last quarter?"), they can find the answer themselves with a few clicks. This is the essence of self-service analytics.

We will explore two key tools for this:

• Slicers: Interactive controls that sit directly on the report canvas.
• Filters: Rules applied "behind the scenes" in the Power BI Filter pane.

Let's dive into what they are and how they differ.

Understanding Slicers vs. Filters

At a high level, both slicers and filters do the same thing: they narrow down the data shown in your visuals. However, they are designed for different purposes and users.

• Slicers are visual elements on the report page, like dropdowns or buttons. They are intended for the end-user (the manager) to interact with.
• Filters are configured in a dedicated pane. They are typically set up by the report creator (you or the manager building the report) to establish a baseline context.

To get a clear overview, please read the introductory sections of the following guide.

This table provides an excellent summary of the differences, which you can use as a teaching aid in your workshop.

Adding Slicers for User-Driven Exploration

Slicers are the most visible and intuitive way for managers to explore data. They are added to the report just like any other visual.

Let's watch a short video that demonstrates how to add a slicer and introduces the Filter pane, which we'll discuss next.

Once a slicer is on the page, you can customize its appearance. For example, you can change it from a list to a dropdown to save space, or even to horizontal buttons. You can show your workshop participants how to do this in the Format visual pane under Slicer settings.

Using the Filter Pane for Report-Level Control

The Filter pane offers a more powerful, behind-the-scenes way to control the data. Its key feature is the ability to apply filters at different levels, or "scopes."

This video segment explains these scopes clearly.

For your workshop, the most important distinction for managers to grasp is between Page-level filters and Slicers. Both filter the entire page, but their use cases differ. A page-level filter is good for setting a condition that the user doesn't need to change often, while a slicer is for frequent, interactive filtering.

Advanced Control: Deciding What Gets Filtered

By default, a slicer affects every other visual on the page. But what if you don't want that? For instance, you might have a KPI card showing total company sales that should not change when a user filters by a specific region. Power BI gives you precise control over these interactions.

Furthermore, what if you want a slicer on one page to also apply to another page? This is essential for creating a cohesive, multi-page report. The Sync slicers feature handles this.

The following video from "Analytics with Nags" explains these important concepts.

The official Microsoft documentation on Slicers in Power BI (ID: LINK) is also an excellent, comprehensive resource you can refer to for more detail on these features.

Conclusion

In this lesson, you've learned how to empower your workshop participants to turn their reports into interactive analytical tools. Giving managers the ability to filter, slice, and dice data themselves is a fundamental step in fostering a data-driven culture.

Key Takeaways for Your Workshop:

• Slicers are for Users: Use slicers for common filters (like date, region, or category) that you want managers to interact with directly on the report canvas.
• Filters are for Creators: Use the Filter pane to set up the underlying context of a report, such as filtering out irrelevant data or setting a default scope that users won't change.
• Different Scopes for Different Needs: The Filter pane can operate on a single visual, a whole page, or the entire report.
• Slicers Offer More Control: With features like Edit Interactions and Sync Slicers, slicers provide more flexible and sophisticated user experiences than page-level filters.

Preview of the Next Lesson:
We've just seen how to explicitly filter a report using slicers. But Power BI also has a powerful implicit filtering capability. In the next lesson, Describe how visuals interact through default cross-filtering, we'll explore what happens when you click on a bar in a bar chart or a segment in a pie chart, and how that simple action can be used to filter all other visuals on the page.