Hi Ameya,

Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread

Approach is explained here

1. P1. Select Date

2. D1. Select Date conversion:

IF [P1. Select Date]="Today" THEN TODAY()

ELSE DATE([P1. Select Date])

END

3. M1. YTD:

if DATEDIFF('year',[D1. Select Date conversion],[date])=0

and [date]<[D1. Select Date conversion] then [value] END

4. Drag required objects to the indicated locations and show parameter control

Regards,

Norbert

Hi Ameya,

If you are using v10.2 and up, you can use the below option.

~Tushar

Hi Ameya,

I have the same question with you。

NOW,I hava two charts that I want to use date linking together。One of the chart showed values in the last thirteen months，and the other showed values in the last month  。IF I  click one of  the last  thirteen months in  the first chart ，the last chart  can change。（tableau v 9.0）

Hi，Tushar，I can't find the option in V10.2

Hi Zhang,

It's available from V10.3 onwards:(

Regards,

Norbert

THANK YOU Norbert ,I find the option in v10.3,but it can't solve the question.

IF I use the option in the first chart and choose other month in the other chart ,there will be no data in  the first chart.

Hi Zhang,

Could you share a workbook in .tbwx format?

Regards,

Norbert

THANK YOU Norbert,I have uploaded it in tableau public。

https://public.tableau.com/profile/zhangcg3377#!/vizhome/1_5162/1

Jamieson Christian can you help me

Hi Zhang,

Find my approach as reference below and stored in attached workbook version 10.4 located in the original thread

1. Define Parameter PERIOD based on PERIOD change Data type to string and add entry "Today".

    Move entry "Today" up to the highest position and set is to Current Value

2. D1.Date converter: if [PERIOD Parameter]="Today" then today() else date([PERIOD Parameter]) end

3. D2. Display: datediff('year',[PERIOD],[D1.Date converter])=0 and [PERIOD]<=[D1.Date converter]

4. Drag required objects to the  indicated locations (both sheets) and filter D2. Display on True & show parameter control

Regards,

Norbert