Quite troublesome, but one idea here.
Prepare the date field for number of formats needed.
Set preferred date format to respective field
And so on.
Then create placeholder as -0.1
Put to 2nd axis and sync.
Put created calculated fields to text on 2nd axis.
Parameter will pick appropriate field with set format.
Tableau Example_SM_10.5.twbx 402.1 KB
Thank you so much for your quick response. This is exactly what I am looking for.
I appreciate your help.
You are very welcome.