Load GANTT chart with timeframe filtered

[shaunguyver]

I have a GANTT chart that, when loaded, I would like to start on today rather than show the full range of items in there. Is this possible?

[v-yuezhe-msft · Accepted solution]

@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

[shaunguyver · Accepted solution]

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?

[v-yuezhe-msft · Accepted solution]

@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

[shaunguyver · Accepted solution]

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?

[v-yuezhe-msft · Accepted solution]

---

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