Filter on a master table do not apply on all tables in Power Query

[Medmbchr]

Hi

I have a Power BI data model in which I have a central table COMPANY with 8 companies, all my other tables (purchase orders, sales etc) are linked to this table via a 1 to many relationship.

I would like to apply a filter on my COMPANY table to select only 2 companies, hence filter all other tables to show only transactions of those 2 companies.

The problem I am facing today is that my filter works well on the report, but the filter doesn't work if I do it on the table in Power Query. I don't want to use report filters since the Power Query filter help reducing the data size.

How can I apply a filter on Power Query so that it applies on all other tables, I have 35 tables ...

I also want to avoid doing the filter manually for each table.

Thanks

[v-jayw-msft]

Hi @Medmbchr ,

Please share some sample data so that we could test formula.