cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

Accepted Solutions
Highlighted
Moderator Eric_Zhang
Moderator

Re: cross filtering

@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

 

 

4 REPLIES 4
Highlighted
Moderator Eric_Zhang
Moderator

Re: cross filtering

@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

 

 

Re: cross filtering

this is really awesome example 

Pateen Frequent Visitor
Frequent Visitor

Re: cross filtering

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?

aBerg Regular Visitor
Regular Visitor

Re: cross filtering

Hi @Eric_Zhang !

 

Simple and objective, congratulations!

 

 

Greetings

Berg

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,027 guests
Please welcome our newest community members: