Error Linked Filter

Get Help
1

Hello,

I have identified some tables in my databases where the linked filters are not working correctly.

Context:

  • I have three filters: Sport, Competition, and Season, all linked to each other.

  • When I filter by Sport (e.g., Handball), all corresponding seasons appear correctly in the database.

  • On the dashboard, only the competitions related to this sport are displayed (which works as expected).

  • However, in the Competition filter, no values appear.

  • Similarly, if I filter by Competition, the selection works, but the other filters remain empty.

I would like the linked filters to display all corresponding values correctly in both directions.

The tables where this issue occurs are: Competition_season_translations and Positions.

Capture d’écran 2026-04-07 à 10.53.37
Capture d’écran 2026-04-07 à 10.53.371188×954 35.8 KB

Capture d’écran 2026-04-07 à 10.53.11
Capture d’écran 2026-04-07 à 10.53.112172×954 233 KB

Capture d’écran 2026-04-07 à 10.52.48
Capture d’écran 2026-04-07 à 10.52.482172×954 180 KB

Capture d’écran 2026-04-07 à 10.52.27
Capture d’écran 2026-04-07 à 10.52.272172×954 195 KB

2

Usually this is due to a missing foreign key relationship.

Can you describe your database schema? Is the Competition data source in the same table as the other two filters, or a different table?

Review the documentation for Linked Filters here and verify the table relationships are properly described in Metabase: