Date Slicer to be based on another Date value in my model

[Anonymous]

Hi community,

I have a date slicer which is an event date column.
All my transactions have an event date and my dashboard is filtered by a slicer based on the event date.

However, there is another date from a different table which is Adoption manager assigned date. Usually this happens a couple of days after transactions start flowing in.

I need to make my dashboard so the event_date slicer interacts with the assigned date so it actually start counting events from the assigned date. In the Screenshot below the slicer is set at 02/02/2023 and it starts counting events from 03/03/2023 since this was the first event that happened in that range. I need it to start counting from 16/03/2023 which is the Date Assigned date.

The two tables are connected through the data model.

[Anonymous]

Thanks people. This was helpful.

[SivaMani · Accepted solution]

@Anonymous, Can be achieved with a Date table. Follow the below steps

1. Create a Date table if you don't have it already
2. Join the date table to both your tables (event date and assigned date)
3. Change the slicer to use Date from the #1 table
4. Create a measure to count records of table that has assigned date

[vicky_]

Create a measure like:
DateSlicerFilter = IF(SELECTEDVALUE([SlicerDate]) >= [DateAssigned], 1)

and use that on the visual filter for your date slicer to only return dates after assigned.