Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I created a chart using the free Microsoft 2.2.3 Gantt chart visual. The data that I used only has a required date (start date) with only the tasks completed having an end date. To display the data, I created a duration column. The following is a sample dataset.
Project Turnover Task | Date Required (MM/DD/YYYY) | Date Completed (MM/DD/YYYY) | Status (Blank, WIP or Completed) (N/A; WIP; Complete) |
Task 1 | 3/5/2024 | 3/1/2024 | Complete |
Task 2 | 3/5/2024 | 3/5/2024 | Complete |
Task 3 | 3/5/2024 | 3/8/2024 | Complete |
Task 4 | 4/2/2024 | WIP | |
Task 5 | 6/1/2024 | ||
Task 6 | N/A | ||
Task 7 | 7/1/2024 | WIP |
The chart itself looks correct but the hover is not reporting the data properly. Please see the screenshot below. I need to at a minimin suppress the End Data field, which is reflecting 1 day when the duration is actually negative.
I have read and tried to implement quite a few post suggestions but nothing worked.
Is there away (maybe using Python) to display my own hover data fields? Any suggestions are appreciated!!
Hi @Strongbuck ,
Base on your description, it seems that you’re experiencing issues with the duration being displayed incorrectly, it might be due to how the duration is being calculated. If the duration is negative, it might be worth checking the formula used to calculate the duration to ensure it’s correct. How did you set the Gantt visual? Could you please provide the related formula of calculating the duration?
In addition, please check if there are other Gantt chart visuals available in the Power BI marketplace that might offer more customization options. For example, 'Gantt Chart-xViz’ is one such visual that allows adjustments to be made.
Best Regards
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |