Cross-filtering between visuals in Power BI - Step-by-Step Guide

Introduction

Cross-filtering lets you click on one chart to change the data shown in other charts on the same report page. This helps you explore data by focusing on specific parts without changing filters manually.

When you want to see how sales in one region affect product performance in other charts

When you need to explore customer segments by clicking on a pie chart slice and see related details in a table

When your dashboard should update multiple visuals dynamically based on user clicks

When you want to compare data subsets by selecting bars in a bar chart and seeing filtered trends in a line chart

When you want to drill down into data categories interactively without creating separate report pages

Steps

Step 1: Open your report in Power BI Desktop

- Report view

You see all your visuals on the report canvas

Step 2: Click on a visual you want to use as a filter source

- Report canvas

The visual is selected and shows a border around it

Step 3: Click the Format icon (paint roller) in the Visualizations pane

- Visualizations pane

Format options for the selected visual appear

Step 4: Select the Edit interactions button on the ribbon under the Format tab

- Format tab on the ribbon

Filter icons appear on all other visuals on the page

Step 5: Click the filter icon on each visual you want to cross-filter

- Filter icons on other visuals

Those visuals will update based on selections in the source visual

Step 6: Click outside the visuals or press the Edit interactions button again to exit interaction mode

- Report canvas or Format tab

Filter icons disappear and cross-filtering is active

Step 7: Click on data points in the source visual to see other visuals update

- Source visual on report canvas

Other visuals show data filtered by the selected data point

Before vs After

Before

All visuals show data for all regions and products without interaction

After

Clicking a region in the map visual filters the sales and product charts to show only data for that region

Settings Reference

Edit interactions

📍 Format tab on the ribbon

Controls how one visual affects others: filter removes unrelated data, highlight dims unrelated data, none disables interaction

Default: Filter

Cross-filter direction

📍 Model view > Manage relationships

Determines if filtering flows one way or both ways between tables, affecting cross-filtering behavior

Default: Single

Common Mistakes

Not enabling Edit interactions before trying to cross-filter

Without enabling Edit interactions, visuals do not know how to respond to clicks on other visuals

Always click Edit interactions on the Format tab to set how visuals filter or highlight each other

Setting interaction to None on visuals that should update

This disables filtering from the source visual, so no cross-filtering happens

Choose Filter or Highlight on visuals you want to respond to clicks

Summary

Cross-filtering lets you click one visual to filter others on the same report page.

Use Edit interactions on the Format tab to control how visuals affect each other.

Remember to set interactions to Filter or Highlight, not None, for cross-filtering to work.