How to pass same daterange from one date slicer to multiple date slicers.

[Mahi1827]

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.

Thanks,

Mahi

[v-frfei-msft · Accepted solution]

Hi @Mahi1827 ,

We shoud create a CALENDAR table like that and establish relationship between tables.

date = CALENDARAUTO()

Then we can filter our visuals based on the date table.

[amitchandak]

You need to create a common date table and join with all dates. If they are in the same table one will active and others will be inactive. You can make them active using userelation.

This blog has the example for the same :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...