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

# Create/Modify Dashboard Filter

> Dashboard filters allow for more precise data viewing and analysis within your dashboard.

> Take control of your data exploration with Databrain's powerful dashboard filters. Whether you
> need simple dropdowns, dynamic ranges, or complex SQL-based filtering, our comprehensive
> filter system puts precision data analysis at your fingertips. This guide walks you through creating
> and customizing filters that transform how you interact with your dashboards.

1. **Add Dashboard Filters:**

* Click the "+" icon to add a dashboard filter.
* Choose filter type from the dropdown menu:
  * **Select**: Creates filters at the top of your dashboard
  * **Switch Select**: Creates compact dropdown filters with labels in the left sidebar **"Filters"** panel
  * **Other**: Creates additional filters in the left sidebar **"Filters"** panel

<Frame alt="Add dashboard filter from filter creation panel">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/acJVn7w4urVkmFSA/images/guides/add-dashboard-filter.png?fit=max&auto=format&n=acJVn7w4urVkmFSA&q=85&s=59ff5e6822ff3bef9271a0e5ac3a171c" alt="" width="2940" height="1660" data-path="images/guides/add-dashboard-filter.png" />
</Frame>

2. **Configuring a Filter:**

Choose the desired type of filter from the **"Option Type"** radio buttons:

* **Method 1: Auto Filter Type**\
  Automatically filters based on existing database columns - best for straightforward data filtering without customization.
* **Method 2: Range Filter Type**\
  Creates min-max sliding selectors - perfect for numerical data like prices, ages, or quantities.
* **Method 3: Date Filter Type**\
  Handles all time-based filtering - ideal for selecting date ranges and time periods.
* **Method 4: Manual Filter Type**\
  Uses predefined static options - great when you need a fixed list of specific choices.
* **Method 5: Custom Filter Type**\
  Enables complex SQL-based filtering - essential when you need custom logic or calculations in your filters.

**Common Customization Options**

* **Filter Variant**: Choose between single select, multi-select, or search options
* **Choose a Unique Label Column**
* **Show Client Scoped Filter Options**
* **Auto Select Default Value**
* **Depend On**

**Method 1: Auto Filter Type**

<Frame alt="Auto filter configuration with filter variants and advanced options">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/jzYViQJeLwpwFJzr/images/guides/auto-metric-filter.gif?s=9b781f74925598f573a478408bb6f3d8" alt="" width="1631" height="919" data-path="images/guides/auto-metric-filter.gif" />
</Frame>

**Method 2: Range Filter Type**

<Frame alt="Range filter configuration panel showing min-max selector options">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/KRwjKFDucjw_bmHb/images/guides/range-metric-filter.png?fit=max&auto=format&n=KRwjKFDucjw_bmHb&q=85&s=e3982d2901e44b2c07a005f9e01b7570" alt="" width="2940" height="1658" data-path="images/guides/range-metric-filter.png" />
</Frame>

**Method 3: Date Filter Type**

<Frame alt="Date filter creation showing date selection and restrictions options">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/XcIJns6h_rN1QLlV/images/guides/date-metric-filter.gif?s=48f44c6a254868f3140937ba8ce5c475" alt="" width="1630" height="919" data-path="images/guides/date-metric-filter.gif" />
</Frame>

**Method 4: Manual Filter Type**

* Manual filter options are entered **one by one** in the UI: for each option, enter a **Value** (the exact value used in the query) and a **Label** (what users see in the dropdown). You do not paste a full JSON structure—add options using the UI (e.g. "Add option" or similar).

<Frame alt="Manual filter configuration with custom static options">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/KRwjKFDucjw_bmHb/images/guides/manual-metric-filter.gif?s=1eb059d18a7a2e53fd4ea805e1ff2342" alt="" width="1633" height="918" data-path="images/guides/manual-metric-filter.gif" />
</Frame>

**Method 5: Custom Filter Type**

<Frame alt="Custom SQL-based filter creation using SQL editor">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/jzYViQJeLwpwFJzr/images/guides/custom-metric-filter.gif?s=77dd82173196d97b0e9f80141be7d0c2" alt="" width="1630" height="919" data-path="images/guides/custom-metric-filter.gif" />
</Frame>

3. **Apply on and Variable Filter:**

<Frame alt="Apply on and variable filter settings in dashboard filter configuration">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/acJVn7w4urVkmFSA/images/guides/apply-on-and-variable-filter.gif?s=01ecbc6eb43217d585ee416aa9b25f34" alt="" width="1389" height="1079" data-path="images/guides/apply-on-and-variable-filter.gif" />
</Frame>

<Info>
  For a more detailed guide on Variable Apply On, kindly refer the below link:
</Info>

<Card title="Dashboard Filter - Variable Apply On" href="https://docs.usedatabrain.com/guides/dashboards/create-modify-dashboard-filter/dashboard-filter-variable-apply-on">
  Functioning of Variable Apply On method available in Dashboard Filters.
</Card>

4. **Modify Dashboard Filter:**

* To modify the configurations of any dashboard filter, click on the **"Edit"** button.
* To remove a filter, select **"Delete"** filter.

<Frame alt="Modify or delete existing dashboard filters">
  <img src="https://mintcdn.com/databrainlabs-bef6850a/KRwjKFDucjw_bmHb/images/guides/modify.png?fit=max&auto=format&n=KRwjKFDucjw_bmHb&q=85&s=d72c2915c330a89edd1e1216207315b6" alt="" width="2940" height="1654" data-path="images/guides/modify.png" />
</Frame>

<Check>
  Dashboard Filter created and configured successfully.
</Check>