KNOWLEDGE BASE

Show the Latest Date of Data Source as Default Value in Parameter


Published: 13 Oct 2020
Last Modified Date: 09 Dec 2022

Question

How to set a parameter to show the latest Date in the data source.

Environment

  • Tableau Desktop 2020.1 and later

Answer

Use Dynamic Parameter (available in Tableau Desktop 2020.1 and later).

1. Create a calculation field to get the latest date in the data source
Field name: ! Max Date
Calculation: {MAX([Order Date])}

2. Create a Parameter, set the [Data type] to [Date], and set [Value when workbook opens:] to [! Max Date]
Did this article resolve the issue?