Forum Discussion
Filter by all projects currently active on a specific date
1.Create a date table, don't connect thsi new date table to any other table,
date1 = CALENDARAUTO()
Add "date" from this table to a slicer.
2. create measures in your table
selected date = SELECTEDVALUE(date1[Date]) active_specific_date = IF([selected date]<=MAX(Sheet12[end])&&[selected date]>=MAX(Sheet12[start]),1,0)
Add [active_specific_date] in the visual level filter of the Gantt chart,
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie ( v-juanli-msft ),
Yes, the data for the dates that you provided is exactly how our data is structured. So we can link the start date, and we can link the end date, but we can't pick a certain date between the start and end dates.
The image I provided is just an example of one of the visuals that would use the data. The issue we are having is that we have no date and time linkages to span the date range, so we can use it for the filtering.
Community SupportIs this problem sloved?
If not, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.