Forum Discussion
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/
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.
4 Replies
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.
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?
