Parameters are workbook variables that can replace a constant value in a sheet or dashboard. They can come in string, number or date format.
To create a parameter, click on the dropdown in the left pane and select Create Parameter.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-191.png)
The parameter creation box will appear:
![](https://www.thedataschool.co.uk/content/images/2023/01/image-192.png)
Add a name for the parameter and specify the data type. In this case, I'm making a simple parameter that helps a user filter to different Regions in the Superstore dataset:
![](https://www.thedataschool.co.uk/content/images/2023/01/image-197.png)
Select a data type for the values it'll accept. I've chosen string because this parameter will have a list of locations.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-199.png)
Specify a current value. This is the default value that this parameter will take. My current value is 'Central', a region in the superstore dataset.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-207.png)
Select a value for when the workbook opens:
![](https://www.thedataschool.co.uk/content/images/2023/01/image-206.png)
Choose how the parameter accepts values - this can either be All, a List or a Range.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-209.png)
You can add values from an existing fields. I'm adding the values from the Region field.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-210.png)
Click okay and your parameter is ready to use.