cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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.

 

Thanks,

Mahi

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

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...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors