# Dropdown

Plan allows you to create single-select or multi-select dropdown columns using predefined lists of values. 

* **Single select** allows only one value to be selected.
* **Multi-select** allows multiple values to be selected.
* Presets are available only for single-select columns.

### Create a dropdown column

To insert a dropdown column:

1. Go to **Planning** > **Insert Column** > **List.**
2. Select **Single Select** or **Multi-select.**

<figure><img src="/files/Avc3am04c2v6dFNHR1Ua" alt="" width="563"><figcaption></figcaption></figure>

### Create a list of values

After selecting **Single Select** or **Multi-select**, a side panel opens where you can define the list of values (LOVs) using **List** or **Presets**.

<figure><img src="/files/uwZEIEmenKYgHlQPYvnR" alt="" width="375"><figcaption></figcaption></figure>

#### List

1. Selecting **Options** > **List** displays three default options with colors.
2. You can rename, add, or [modify these options](#modify-list-of-values).
3. Select **Create** to apply the list.

<figure><img src="/files/OuwbUHXzHhywQCjaL0nY" alt="" width="375"><figcaption></figcaption></figure>

#### Presets

1. Selecting **Presets** opens a list of predefined value sets.
2. Hover to preview the values.
3. Select a preset and choose **Apply.**

<figure><img src="/files/Gy42HizmuEcqrLm59oPw" alt="" width="563"><figcaption></figcaption></figure>

### Modify list of values

You can modify an existing dropdown column using the same steps as other data input columns. For more information, see [modify column](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/insert-manual-input-columns.md#modify-column-properties) *properties*.

1. Go to **Manage measures** and select the **Edit** (pencil) icon.
2. Alternatively, use the column gripper of the dropdown column and select **Edit Measure.**
3. Selecting **Edit** opens a side panel where you can update the required properties and perform the following actions:

* **Edit options**: Modify option names by typing over existing values or change colors using the color picker.

<figure><img src="/files/0AG1pDxjtlYWkN3u2tXE" alt="" width="563"><figcaption></figcaption></figure>

* **Add options**: Select **Add option**, enter a value, and press Enter.
* **Delete or reorder options**: Use the available icons.

<figure><img src="/files/tnJvfW44UoYZ93TUU24s" alt="" width="375"><figcaption></figcaption></figure>

4. After making the changes, select **Update**. The Update button is enabled only after changes are made.

### Localize list of values

Plan allows you to display dropdown values in different languages based on user preferences, which is useful for global teams.

To configure localization:

1. Go to **Format** > **Translations.**&#x20;
2. Add translation entries for the required keys and languages using the **Add New** option or the **+** icon by hovering over a row.
   * Alternatively, you can import an Excel file in the same format available in the **Translate** tab.
3. Select **Save** to apply the changes.

<figure><img src="/files/1y2p1QOQ9ZQ00PdMZhrL" alt=""><figcaption></figcaption></figure>

4. In the **Single Select** data input column, use the *GETLOCALELABEL* function in the **Options** field and pass the key defined in the localization settings.

When the report language changes, the dropdown values are automatically displayed in the selected language.

#### Example

In the example below, the dropdown options are displayed in French based on the current language settings.

<figure><img src="/files/28oyx4OUUNrAIkdcWUn2" alt=""><figcaption></figcaption></figure>

### Configure dropdown properties

Common Properties such as **Insert as**, **Allow Input**, **Default Value** and **Description** can be configured. For more information, see [configure data input column properties](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns.md#configure-data-input-column-properties).

In addition, you can configure the following properties for dropdown columns:

* **Options style**: Choose how dropdown values are displayed - **Chip**, **Arrow** or **Plain text.**

<figure><img src="/files/6LzLRdxSAmxDt6fzioZe" alt=""><figcaption></figcaption></figure>

* **Icon position**: Choose the desired icons and control where the icon appears in the option:
  * Display on the left or right
  * Not applicable for **Chip** style

<figure><img src="/files/pmaCDXMLbR70iV3c41c8" alt=""><figcaption></figcaption></figure>

* **Allow users to add new options**: When enabled, users can create new options directly from the dropdown without opening the configuration panel.

<figure><img src="/files/iDJK5YG9i7qvEdADa9mw" alt=""><figcaption></figcaption></figure>

* **Entry in total and subtotal rows**: Enabled by default. Disable **Allow entry on Total/Subtotals** to restrict input in total and subtotal rows.

<figure><img src="/files/QN5SFvjR38UNuHlYLHee" alt=""><figcaption></figcaption></figure>

* **Default value**: Define a default selection to avoid empty values:

  * **Static** - Select a predefined value from the dropdown values.

  <figure><img src="/files/vN9uqnOjlU0yeSQWofZ8" alt=""><figcaption></figcaption></figure>

  * **Dimension** - Use a dimension category.

  <figure><img src="/files/6P0YqLJv66SXHl67SBp6" alt=""><figcaption></figcaption></figure>

  * **Measure** - Use a measure.

{% hint style="info" %}

#### Note

When using **Dimension** or **Measure** as the **Default Value**, enable **Allow user to add new option.**
{% endhint %}

### Use the dropdown

After configuring the column and list of values:

1. Select **Create.**
2. Click a cell in the column to open the dropdown.
3. Choose the required value.

<figure><img src="/files/0IMBHYPWvZecNZHyueJo" alt="" width="563"><figcaption></figcaption></figure>

For **Multi-select**, you can select multiple values in a single cell.

<figure><img src="/files/yU9zRLgowCbYcztiHrF8" alt="" width="563"><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.