3 Essential Ways to Use Dynamic Parameters in Tableau

To make this parameter dynamic we are going to select the second radio button next to the list of allowable values called “When workbook opens”. A dropdown will appear and from that dropdown we will select Sub-Category, then click OK.

This is saying that each time the workbook is opened, Tableau will look for any new sub-categories and if one is found it will be added to the list of allowable values.

We have just made this parameter dynamic. Easy, right?!

Now let’s test it out. I am going to close the Tableau workbook and open the Sample – Superstore dataset in Excel.

In the Sub-Category column, I am going to change a value to Widgets and another value in that column to Gadgets. This is going to simulate that two new sub-categories were created in our dataset.

I will save that file, close it, and reopen Tableau. If everything worked correctly, we should now see Gadgets and Widgets in our list of allowable values.

I highlighted Gadgets and Widgets is at the bottom of the list. This worked perfectly and will now dynamically update even if additional sub-categories are introduced.

How to dynamically change a date parameter to the latest date

For this example, I have created my own dataset with values from 1/1/2020 through 10/1/2020. I have plotted the data on a dual-axis combination chart.

This line graph will highlight the selected date on the graph using the date parameter. What I want this to do is dynamically update to the latest date each month new data comes in. For instance, in November when the data refreshes, I want November 2020 to be highlighted.

To do this we will setup the parameter in a similar way as the previous example. However, not only do we want Tableau to load in the new values, we also want Tableau to select that new value once the workbook loads. To accomplish that we need to create a calculated field that will be used to pass Tableau the value to select.

First, we will right-click any blank space in the Data pane and select “Create Calculated Field”. I will title my new field “Max Date” and the calculation will be as follows:

{MAX([Date])}

This will return the FIXED MAX date in the dataset.

I will click OK.

Next, I will right-click on my Month Parameter in the Data pane and select “Edit”.

Just like before in the lower-right corner, I will select the “When workbook opens” radio button and choose my Date field from my dataset. However; I am also going to click on the dropdown next to “Value when workbook opens”. This is the third dropdown from the top in the Edit Parameter dialog. In this menu I will select our new Max Date calculated field.

Then I will click OK.

Once again, I am going to close Tableau and open my dataset in Excel.

As I mentioned before, I currently have values from 1/1/2020 through 10/1/2020.

I am going to create an entry for 11/1/2020 and add a new value in it. This is going to simulate as if we are in Nov 2020 and my data just refreshed.

Now I will save that, close Excel, and reopen my Tableau workbook.

When I did you can see that the parameter dynamically loaded in the latest data, but also moved the highlighted date to the latest month in the dataset!

This is just one way to use dynamic date parameters. You can also use this feature when using the popular Start and End Date parameter setup. If you made both the start date and end date parameters dynamic, they would automatically update to a specific date or date range each time the workbook is open.

How to dynamically update list of allowable numerical values using benchmarks

To begin I will create a new sheet in Tableau and drag sum of Profit to the Rows Shelf and continuous Month of Order Date to the Columns Shelf. This gives me a line graph of profit by month.

For our benchmarks, I have again created a new data source in Excel and loaded some values from three of our competitors.

I will connect to my new data source by clicking Data in the top navigation and selecting “New Data Source”. I will select Excel as my connection type and click on my new data source.

With the data source added, I will create a new parameter for my benchmarks. I will right-click in a blank space in the Data pane and select “Create Parameter”. I will title the parameter Competitor Benchmarks, click the List radio button, then click the “When workbook opens” radio button. Next, I will simply select Value from my benchmark dataset and the values will preload into the list. This can be a nice shortcut if you are dealing with loading a lot of values in a list initially because you don’t have to type them into the list.

To get these benchmarks to display on the line graph I created, I am going to right-click on the y-axis and select “Add Reference Line”.

In the dialog box, I will select Competitor Benchmarks in the “Value” dropdown, change the line color to red, and click OK.

Now that we have the benchmark parameter setup, I will close Tableau, navigate back to my benchmark data source, and add a fourth competitor.

I’ll save that file and reopen Tableau.

As expected, Tableau dynamically updated the parameter with the new value.

Until next time,
Ethan Lang
Director, Analytics Engineering
[email protected]