Here’s how to enable drilldowns for bar charts
chart_id.category
as shown below.
You can then use the new variable as you would any other variable generated from
a filter or dropdown in the SQL editor or in the filter config for individual
charts.
For more information on how to use variables, you can reference the docs
here.