The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |