cross filtering

[brunozanoelo]

Hello, could anyone explain to me how cross filtering works? Some use case could help me.

I already read the explanation from Microsoft, however, I did not understand.

Https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-bidirectional-filtering/

[Eric_Zhang · Accepted solution]

@brunozanoelo

If you mean the single/both direction, Check

4 tables in excel.

Load them to Power BI desktop and create relationship with cross filter single/both direction.

Then check how the direction works among visuals.

When filtering the left tables, the right tables are filtered.

When filtering the right tables.

Only the left table in a both direction is filtered.

[aBerg]

Hi @Eric_Zhang !

Simple and objective, congratulations!

Greetings

Berg

[Pateen]

Hi @Eric_Zhang 

A really well explained example.

In your last sample you mentioned above “When filtering the right tables. Only the left table in a both direction is filtered.”
Is there any way of setting up a relationship where if you filter either the left OR the right table then filtering is applied to its oppisite table, equivalent to an inner join?

[Anonymous]

this is really awesome example