Relationship direction and cross-filtering in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does relationship direction mean in Power BI?

Relationship direction controls how filters flow between tables. It determines which table filters the other when you select data.

beginner

What are the two types of cross-filtering directions in Power BI?

Single direction: filters flow from one table to another.<br>Both directions: filters flow both ways between tables.

intermediate

Why would you use both directions cross-filtering?

To allow filtering from either table in a relationship, useful in many-to-many or complex models where you want filters to affect both sides.

intermediate

What is a potential risk of using both directions cross-filtering?

It can cause ambiguous relationships and circular filter paths, which may lead to incorrect or slow calculations.

advanced

How does cross-filtering direction affect DAX calculations?

Cross-filtering direction controls which tables are filtered automatically in DAX. It affects functions like CALCULATE and FILTER by controlling filter context flow.

In Power BI, what does single direction cross-filtering mean?

A Filters flow both ways between tables

B Filters flow only from one table to another

C Filters do not flow between tables

D Filters flow randomly between tables

Single direction means filters flow only from one table to the related table, not back.

Which cross-filtering direction can cause ambiguous relationships?

A Both directions

B No direction

C Single direction

D Inactive direction

Both directions can create circular filter paths causing ambiguity.

What is the default cross-filtering direction when you create a relationship in Power BI?

A Inactive

B Both directions

C Single direction

D No filtering

By default, relationships use single direction filtering from the one side to the many side.

When should you consider using both directions cross-filtering?

A When you want filters to flow only one way

B When you have no relationships

C When you want to disable filtering

D When you want filters to flow both ways for complex models

Both directions are useful in complex models needing filters to flow both ways.

How does cross-filtering direction affect report visuals?

A It controls which visuals can filter others

B It controls the color of visuals

C It controls the size of visuals

D It controls the font style

Cross-filtering direction controls how selections in one visual filter data in related visuals.

Explain relationship direction and how it controls filter flow in Power BI.

Think about how selecting data in one table affects another.

Describe a scenario where both directions cross-filtering is useful and what risks it might bring.

Consider many-to-many relationships or complex models.