How to pass same daterange from one date slicer to multiple date slicers.
We have 3 date slicers Invoicedate, Sales date, order date. The date in the slicers are populated from 3 copies of the same table (KPI_DATE) to avoid loop in the data model
Invoicedate--> (KPI_DATE1) Sales date--> (KPI_DATE2) order date--> (KPI_DATE3)
Our goal is to calculate 3 measures Invoice_KPI_count, Sales_KPI_Count,Orderdate_KPI_Count based on date selected in the date Slicer (Invoicedate,Sales date,order date).
Now as per the user requirement these 3 dates should always remain same i.e if they selected invoice date range is between 01/01/2018 and 12/31/2018, then Sales date and Orderdate ranges should also be between 01/01/2018 and 12/31/2018. . In current scenario we are manually passing the dates separately in 3 diffrent date slicers. So, is there any way to pass the date range in 1 date slicer (invoice date) so that other 2 date slicers (Sales date,Order date) should also be populate in the same date range.