Filter context concept in Power BI - Step-by-Step Guide

Introduction

Filter context controls which data is included when Power BI calculates a value. It helps show results for specific parts of your data, like sales for one region or one product category.

When you want to see total sales only for the current year on a report.

When your dashboard needs to show revenue by each product category separately.

When you want to compare monthly sales but only for a selected region.

When you create a measure that should change based on slicer selections.

When you want to filter data dynamically without changing the original dataset.

Steps

Step 1: Open your Power BI report

- Power BI Desktop main window

You see your report with visuals and data loaded

Step 2: Add a slicer visual

- Visualizations pane

A slicer appears on the report canvas

💡 Use slicers to create interactive filters for your report

Step 3: Drag a field like 'Region' into the slicer

- Fields pane to slicer visual

Slicer shows all regions as selectable options

Step 4: Click a region in the slicer

- Slicer visual on report canvas

All other visuals update to show data only for the selected region

Step 5: Create a measure using DAX that sums sales

- Modeling tab > New measure

A new measure appears in the Fields pane

💡 Example measure: Total Sales = SUM(Sales[Amount])

Step 6: Add a card visual and drag the measure to it

- Visualizations pane and Fields pane

Card shows total sales filtered by the slicer selection

Before vs After

Before

Report shows total sales for all regions combined: $1,000,000

After

After selecting 'West' region in slicer, visuals show sales only for West: $250,000

Settings Reference

Slicer selection

📍 Slicer visual on report canvas

Controls how users filter data by choosing one or more values

Default: Multi-select enabled

Visual interactions

📍 Format tab > Edit interactions

Controls how slicers and filters affect other visuals

Default: Filter

Common Mistakes

Expecting a measure to ignore slicer filters automatically

Measures respect filter context by default, so slicer selections affect results

Use DAX functions like ALL() to remove filter context if needed

Not adding fields to slicers or filters to create filter context

Without slicers or filters, filter context does not change and results stay the same

Add slicers or page/report filters to control filter context interactively

Summary

Filter context controls which data is included when Power BI calculates values.

It changes dynamically based on slicers, filters, and visual selections.

Measures respect filter context unless explicitly told not to.