Forum Discussion

KChyshMelly11's avatar
KChyshMelly11
Frequent Visitor
7 years ago
Solved

Filter by all projects currently active on a specific date

Hello,    I am trying to filter to show all projects currently active on a specific date.    In our data, we have a start date and an end date for the project and we would like to filter on a spe...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi KChyshMelly11 

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi KChyshMelly11 

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.