cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaunguyver
Helper III
Helper III

Load GANTT chart with timeframe filtered

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?

3 ACCEPTED SOLUTIONS
v-yuezhe-msft
Microsoft
Microsoft

@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)
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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?

View solution in original post


 

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Microsoft
Microsoft

@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)
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!