Gantt Chart displaying only the data of selected Quarter

[Divya_Kandasamy]

Hi,

I am trying to creat a Gantt Chart for projects that are in different phases (In pipeline, In progress, Test, Production).

I use Gant 2.2.3 with below details,

• Start Date of the project in Start Date
• End Date of the Project in End Date
• Project Name as Task
• Phase of the project as Legends
• Team name as Parent

I just need to filter these projects based on Fiscal Year and Quarter (I have added them as Slicer). The Fiscal Year that I use, starts on Saturday (either end of Jan or start of Feb). So, I dont have a static month to be selected for the chart. Also, I have to filter them based on Quarters.

Example: If my project is in FY21 and the duration of that project is from Q1 to Q3 (Feb - Oct), and if I select Q1 then the chart should display only the month of that Q1 (Feb, March and April) and not all 9 months, irrespective of Start Date and End Date. 

I am getting the chart as below which needs to be fixed.

Kindly help me to achieve this at any possible way. Thanks in advance!

[v-henryk-mstf]

Hi @Divya_Kandasamy ,

May wish to create a measure, use the SELECTEDVALUE function, set the date selected by the slicer to 1, and then put it into the filter in the Gantt Chart visual. As shown in the screenshot below, try to see if it works.

Measure = IF(SELECTEDVALUE(Tasks[Start]),1,0)

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Divya_Kandasamy]

Hi @v-henryk-mstf 

Sorry for the late response.

I tried creating a measure same as yours but still I did not see any difference. 

[v-henryk-mstf]

Hi @Divya_Kandasamy ,

Can you provide test data (delete sensitive information), otherwise I cannot do further tests.

 Looking forward to your reply.

Best Regards,
Henry

[v-henryk-mstf]

Hi @Divya_Kandasamy ,

First, you need to update pbi to the latest version. Then please format the columns to be dragged in Start and End fields, as Date or Date/Time. 

I did a similar test and the slicer can filter the results correctly:

For more details, you can read related blog as below:

How to Create a Gantt Chart in Power BI (Fast and Easy) (spreadsheeto.com)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Below is my example pbix file.

[Divya_Kandasamy]

@v-henryk-mstf 

Thanks for your response. The chart works fine if the data falls in the same quarter. My data runs through various quarters. 

For Example, If my start date and end date are in Q1 then it works as expected but if my start date is in Q1 and end date is in Q4, then it displays all 4 quarter. I tried with latest version as well.