Filtering is not applied to related tables

[keithlimper]

I want a filter from one table to apply to the releated data in other tables. Does anyone know how to set that up?

I've added three unrelated tables and under Relationships I've linked the tables together. Now I want the filter in the one table to apply or be cascaded to the related tables. I'm trying to load data just for one of our customers not all of them. The filter only works in the one table. Power BI Desktop still retrieves all the data from the other tables.

[Eric_Zhang]

@keithlimper

Please ensure that "Cross filter direction" is applied as "Both".

Note: Relationship filtering is limited to a single direction in DirectQuery mode. So if in this mode, some tricky DAX expressions may have to be used to work around.

[keithlimper]

I switched over to Importing the data from SQL Svr and now the cross filter direction is enabled but still does not filter even after setting it to 'Both'. It still only filters in the one table. Let me know if there is something else I can try.

[Eric_Zhang]

@keithlimper

Can you share me the pbix for further diagnosis?

[keithlimper]

Thanks Eric, but the Cross filter direction is disabled and is default to Single. How do I enabled the Cross filter direction feature?