Skip to main content

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 Date parameter - Week Month YearThe select date parameter should show the week format:

 

imagePlease find attached a workbook as an example.

 

Thank you so much!

 

Esther

답변 3개
  1. 2023년 4월 11일 오전 11:20

    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

0/9000