Relationship direction and cross-filtering in Power BI - Step-by-Step Guide

Introduction

This feature controls how data flows between tables in Power BI. It helps decide which table filters the other when you create relationships. This solves the problem of showing correct data in visuals when tables are connected.

When you want a sales table to filter a product table to show only sold products

When you need both tables to filter each other, like customers and orders, to analyze data from both sides

When you want to avoid incorrect totals caused by filters flowing the wrong way

When you build a report with multiple related tables and want to control how slicers affect visuals

When you want to improve report performance by limiting filter directions

Steps

Step 1: Click

- Model view in Power BI Desktop

You see all tables and their relationships as lines connecting them

Step 2: Select

- A relationship line between two tables

The Relationship pane opens on the right showing details of the selected relationship

Step 3: Click

- Cross filter direction dropdown in the Relationship pane

You see options: Single, Both

Step 4: Select

- Single or Both in Cross filter direction

The filter direction changes accordingly; arrows on the relationship line update to show direction

Step 5: Click

- OK button in the Relationship pane

The relationship updates with the new filter direction

Step 6: Test

- Report view by adding visuals using related tables

Visuals filter data according to the new relationship direction

Before vs After

Before

Relationship between Sales and Products tables has Single direction from Products to Sales; filtering Products filters Sales but not vice versa

After

Relationship direction changed to Both; filtering Sales also filters Products, so visuals update based on filters from either table

Settings Reference

Cross filter direction

📍 Relationship pane in Model view

Controls which table filters the other in a relationship

Default: Single

Active relationship

📍 Relationship pane in Model view

Determines if the relationship is used in filtering by default

Default: Active

Common Mistakes

Setting Cross filter direction to Both without checking for circular dependencies

It can cause errors or slow performance because filters loop between tables

Use Both direction only when necessary and ensure no circular filter paths exist

Assuming Single direction always filters from the first table to the second

The direction depends on how the relationship is created; the arrow shows the filter flow

Check the arrow on the relationship line to understand filter flow before changing direction

Summary

Relationship direction controls how filters flow between tables in Power BI

Single direction filters from one table to another; Both allows filtering both ways

Use Both direction carefully to avoid circular filter issues and performance problems