# Dropdown list

They act similar to multi-select lists but require less space than multi-select lists.

### Creating a dropdown list

1. When you create a dropdown list, then a control filter widget named "***Dropdown List (chosen\_column)***" with a dropdown menu will be created.
2. Click on the dropdown menu to view the two nested lists **Include** and **Exclude,** and two collapsible lists **Selected** and **Available**.

<figure><img src="https://files.helpdocs.io/6dnnwn52e3/articles/sn3znouefg/1685900563339/image.png" alt="" width="375"><figcaption><p>Dropdown list</p></figcaption></figure>

3. From the required Business View, select the dimension for which you want to apply filters.
4. Initially, there won't be any values under **Selected,** and all the values will be present under **Available** list.
5. Click on the pencil icon to rename the multi-select control filter.
6. To sort the filter values, click on the sorting icon to sort the values in ascending or descending order.
7. To search for a specific value, start typing the value in the search bar provided above **Selected**. The values matching your input will be displayed.

{% hint style="info" %}
**Available** list will display the first 300 values. Further scrolling will display the remaining values.
{% endhint %}

### Selecting the values

1. Once the user selects the required values, those values will be moved from **Available** to **Selected**.
2. **Include** list displays the list of included values. In that case, the values under **Selected** are the ones that will be considered for filters.
3. **Exclude** list displays the list of excluded values. In that case, the values under **Selected** are the ones that will not be considered for filters.
4. By default, **Include** list will be selected.

{% hint style="info" %}
If you have 200 values and want to select 5 of them, choose **Include** list.\
If you have 200 values but want to select 150 of them, choose **Exclude** list.
{% endhint %}

5. Click on **Clear All** next to **Selected** to unselect all the selected values. The number next to **Clear All** indicates the number of values selected.
6. Click on **Select All** next to **Available** to select all the values available in the column. The number next to **Select All** indicates the number of available values.

{% hint style="info" %}
No filter will be applied if all existing values are moved to the **Selected** list (in case of either **Include** or **Exclude**).
{% endhint %}

7. Once all the required values are selected, click on **Apply** to apply the filter or click on **Undo** to revert to the previously saved state.
8. The filters will be applied to all the charts in the Vizpad that were created using the specific Business View, and a global filter pill will be created that reflects the applied control filter.

<figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/iOpApSlDRJerxSC0lW2s/ezgif-com-video-to-gif-5.gif" alt="" width="563"><figcaption><p>Dropdown list</p></figcaption></figure>
