Forum Discussion
cross 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.
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.
this is really awesome example
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?
