Dropdown functionality on graph

Hi
is it possible to use any drop down list like functionality on time series graph to hold the series of question.

Filter is available. But i am specifically looking for dropdown if possible.

Hi @Prajakta2021
Yes, depending on the data source and with a bit of workarounds - see comments in these issues and upvote by clicking :+1: on the first post
https://github.com/metabase/metabase/issues/5346
https://github.com/metabase/metabase/issues/6583
https://github.com/metabase/metabase/issues/9875

Thanks That Helped.
Got additional question on it. I have created filter on sample dashboard as shown in image. But when i am trying to use dropdown list value. It gives me error(another image)


@Prajakta2021

  1. Post "Diagnostic Info" from Admin > Troubleshooting.
  2. Post the query and which filter type you are using.

issue is happening with my other dataset. Where i am using one text column having more than 500 value to display in dashboard. i have created query like below

select * from SampleDataset.PRODUCTS
where {{id}}

if i havent use dataset name it dosent give me values. my dataset is coming from bigquery.

@Prajakta2021 You have to define the dataset in the FROM-clause:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type

Tried above already.
I have created query which gives me output with no value in filder. as soon as i select something from dropdown it gives me error.

This is the error i am getting

Unrecognized name: DatasetName.TableName at [3:10]

@Prajakta2021 Please read this article carefully:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html
Make sure that the Field Filter that you reference in the sidebar is included in your FROM or JOIN clause.

1 Like

Thanks for details. Issue resolved.