cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brunozanoelo
Helper V
Helper V

cross filtering

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/

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft
Microsoft

@brunozanoelo

If you mean the single/both direction, Check

 

4 tables in excel.

Capture.PNG

 

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

Capture.PNG

 

Then check how the direction works among visuals.

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

Capture.PNG

 

When filtering the right tables.

Only the left table in a both direction is filtered.

Capture.PNG

 

 

View solution in original post

4 REPLIES 4
Eric_Zhang
Microsoft
Microsoft

@brunozanoelo

If you mean the single/both direction, Check

 

4 tables in excel.

Capture.PNG

 

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

Capture.PNG

 

Then check how the direction works among visuals.

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

Capture.PNG

 

When filtering the right tables.

Only the left table in a both direction is filtered.

Capture.PNG

 

 

View solution in original post

Hi @Eric_Zhang !

 

Simple and objective, congratulations!

 

 

Greetings

Berg

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?

this is really awesome example 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors