Sync date filters from different tables

[gushal]

Hi,

I have date columns in two different tables. One is "created on date" and one is "start time". 

When I filter on my report I want these two filters to be synced. So if I filter on year 2020 on "created on date", I want "start time" to also be filtered on year 2020 automatically.

I have tried "sync slicers" but that only works one way. If I set year 2020 it doesn´t automatically set year 2020 in the other filter. But if I choose 2020 manually in the other filter and then remove 2020 from one it automatically remove 2020 from both filters. 

Any idea how this can be solved?

Br,

Gustav

[amitchandak]

@gushal , I do not think that will work. You need join both with common date/year table and use that for filter/slicer