How to manipulate only end date in date slicer without changing start date in other date slicers

[Yoko_mfwg]

Hi all, 

I have a small issue with a multiple date slicers on the same page. As you can see below, I need to use three different date slicers (with different start dates), which are related to three different measures, from three different tables. Unfortunately I couldn't join tables in SQL, becuase there are some particular filters in each, which can't be used in others.

I wanted to see only "transaction_date" slicer on this page (beacuse 95% of the report is based from this slicer's table) and hide other two (so it won't be confusing for viewers). I would like to change only the end date in "transaction_date" slicer and automatically manipulate the end dates in other two slicers, so the measures will change as well.

I tried to relate the tables and use only "transaction_date" slicer, but every time I changed the end date of the "transaction_date" slicer, the start dates in other slicers are changing to the same start date as the first one has. 

Is it possible to change end date of one slicer, which will automatically change only end dates of other slicers?

Thanks in advance.

BR,

Yoko

[lbendlin]

Worst case you will need to maintain three separate Calendar dimension tables, one for each slicer.