I have a database where:
organizations_region.organization_id
is correctly set as a foreign key toorganizations_organization.id
organizations_organization.id
has its Display value set toname
in the data model- Data model settings are synced, visibility is "Everywhere", and types are correctly configured
However, when I:
- Use a Field Filter variable for
organization_id
(ID field) andname
(Text field) - And link them in a dashboard using dynamic filters (e.g., "Region Name is limited by Organization ID")
I get errors like:
“There was a problem displaying this chart”
or the filter does not populate dropdown values correctly.
This only fails for Entity ID to Text linked filters — while similar Text → Text linked filters (like City → State) work as expected.