Dashboard not recognising variables in BigQuery questions

Hi there,

I have a number of queries written in BigQuery that work fine on their own and have variables attached (all are Field Filters) - see screenshot.

When I add those queries to a dashboard and add a dashboard filter, I can't connect the filter to the individual questions as it claims I need to create a variable in those questions first, despite them existing already.

Any idea what the error here is or is this a bug?


Are you sure you are creating field filters? Can you share screenshot of the filters you created

You can see the filters in the first screenshot above ('External ID' and 'Company name'), and I've attached where I've set it up in the Variables tab too!

And you are adding a Text Filter in the dashboard right?

What version of metabase are you running?

Aha you've got it - I was trying to add an ID filter rather than Text. Text has worked fine!

Thanks for your help !

1 Like