> ## Documentation Index
> Fetch the complete documentation index at: https://docs.explo.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Chart Level Filters

> Chart level filters allow you to choose the categories that customers will be able to pick from to view charts.

<img src="https://mintcdn.com/explo/LLLEZyAg4kfqfGcK/images/creating-dashboards/chart-level-filters-1.png?fit=max&auto=format&n=LLLEZyAg4kfqfGcK&q=85&s=c2a832a2af7b1176d337639ef61888ff" alt="" width="1133" height="448" data-path="images/creating-dashboards/chart-level-filters-1.png" />

## Adding the Chart Level Filter

<img src="https://mintcdn.com/explo/LLLEZyAg4kfqfGcK/images/creating-dashboards/chart-level-filters-2.png?fit=max&auto=format&n=LLLEZyAg4kfqfGcK&q=85&s=731e0e85bae4f69daccf4c613eedc890" alt="" width="389" height="154" data-path="images/creating-dashboards/chart-level-filters-2.png" />

In a chart that supports color categorization, you can drag multiple columns
into the color category. If more than one color exists, a dropdown will appear
on the respective chart that the customer can use to switch between views.

<img src="https://mintcdn.com/explo/LLLEZyAg4kfqfGcK/images/creating-dashboards/chart-level-filters-3.png?fit=max&auto=format&n=LLLEZyAg4kfqfGcK&q=85&s=b75b4abd22c127811e1edc0f6be38146" alt="" width="432" height="189" data-path="images/creating-dashboards/chart-level-filters-3.png" />

You can also format the dropdown to appear either in the top right corner or
below the title of the chart. The default placement is top right corner.

## Variable Usage

The selected item in the dropdown will be saved in a variable and can be used
like any other variables across the dashboard.

In the SQL query, use the following syntax

```sql theme={null}
WHERE 1=1
[[AND column_1 = {{<insert dataPanelId>.EXPLO_COLOR_CATEGORY}}]]
```