Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@Anonymous, Can be achieved with a Date table. Follow the below steps
Thanks people. This was helpful.
@Anonymous, Can be achieved with a Date table. Follow the below steps
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.
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
59 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |