@Anastasiia Here's what I wrote in Filters Interaction - #2 by flamber
Using Linked Filters can be a little tricky, since you have to use Field Filters if using SQL, while the Admin > Data Model also needs to make foreign key reference between the tables for it to work.
So Table2 needs an Entity Key, and Table1 needs a Foreign Key referencing Table2's Entity Key.
Metabase has to be able to generate a query, so it if doesn't know how things are connected, then it cannot create such query and will just show all options.