Hi,
I have created a parameter where you can select the format of the date by Week Month Year. I would like to create another parameter where you are able to select the date but I would like that the format of the date in the parameter is shown in the format I have selected in the previous parameter. Is there any way to do this?
Fo r example, if I have selected Week in the Select time dimension parameter The select date parameter should show the week format:
Please find attached a workbook as an example.
Thank you so much!
Esther
Hi @Ester B
Unfortunately, there is no way to achieve this in Tableau only.
One a bit tricky way to get desired output - make some adjustments in the dataset. You need to duplicate yor table 2 times and create new column Selector that will contain Week/ Month /Year. So you'll have 3 tableas - one only with Week in Selector column, other only with Month and third only with Year. Then you nedd one more column for each table - column with desired date formating (sting). At the end you will union these tables and this structure enables you to get desired output.
Hope it helps,
Anastasia