Linking filters not working with 2 or 3 tables

Linking filters not working with 2 or 3 tables.

I tried the linking filters with a single table. The linking worked. When I select a country name the dependable filter shows the state suggestion based on the country name.

Then I use a left join and call cities name. I also make the city name as filter and link to country name state filter. Now the city name suggesting all cities of all countries instead of the filtered country.

Why it is happening?

image

Hi @shaonyuvi
Have a look here https://github.com/metabase/metabase/issues/16872
If your Data Model is not linking the tables, then Metabase has no idea how to create a query for the filter.