Load GANTT chart with timeframe filtered

shaunguyver,

You can create a columns in your table to check the startdate, then drag the column to visual level filters, for more details, please take a look at the following example.

checkdate = IF(Table[Start Date]>=TODAY(),1,0)


Regards,
Lydia

Thanks Lydia,

I'm a little confused, which table is this calc referring to? I don't have any tables in my report, just a GANTT chart.

Also, what is 'checkdate' - is it a calcluation that you've created then dragged to visual level filters in the GANTT chart?

---

 

I'm a little confused, which table is this calc referring to? I don't have any tables in my report, just a GANTT chart.

 

---

shaunguyver,

What fields do you use  to create the GANTT chart, replace the table name and field name in the above DAX with your owns.

"Also, what is 'checkdate' - is it a calcluation that you've created then dragged to visual level filters in the GANTT chart?"

Yes. I create a calculated column.

Regards,
Lydia