Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Help > 
Applies to: Tableau Desktop, Tableau Public

Creating Parameters

You can create a new parameter based on a selected field in the Data pane, or you can create a new parameter from any location where you can use a parameter (for example, as you add a reference line or create a filter). Follow the instructions below to create a new parameter from the Data pane.

  1. In the Data pane, right-click (Control-click on a Mac) a field to base the parameter on and select Create > Parameter.

    Alternatively, you can use the drop-down arrow in the upper right corner and select Create Parameter.

  2. In the Create Parameter dialog box, give the field a Name and optionally write a Comment to describe the parameter.

  3. Specify the data type for the values it will accept:

  4. Specify a current value. This is the default value for the parameter.

  5. Specify the display format to use in the parameter control.

  6. Specify how the parameter will accept values. You can select from the following options:

    The availability of these options is determined by the data type. For example, a string parameter can only accept all values or a list. It does not support a range.

    If you select List, you must specify the list of values. Click in the left column to type a value. Each value can also have a display alias. You can copy and paste a list of values by clicking Paste from Clipboard. Alternatively you can add the members of a field as the list of values by selecting Add from Field.

    If you select Range you must specify a minimum, maximum and step size. For example, you can define a date range between January 1, 2010 and December 31, 2010, with the step size set to 1 month to create a parameter control that lets you select each month in 2010.

  7. When finished, click OK.

    The parameter is listed in the Parameters section at the bottom of the Data pane.

    It is also available everywhere else you can use a parameter—for example, on the Top tab in the Filter dialog box, or in the Reference Line dialog box. Parameters are global across the workbook and can be used in any worksheet.