Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am in great need of help on the Gantt chart. The chart works fine, unless my start and end date are less than 24 hours different. Then the system is CHANGING my end date to exactly 24 hours past my start date. Can someone please help me fix this asap? I am using Gantt 2.2.3 from the Marketplace. @Gantt, @ChangingDataHello!
I have screenshot showing:
The first row IM201909-001 has a Start DT of 9/2/2019 06:51 and an End DT of 9/2/2019 14:51. I created a “True Duration in Days” as 0.33 days as the actual duration is only 8 hours. But the tooltip and the length of the bar are showing as 24 hours past the start date.
But on the third record 09022019-004 the start date is 9/2/2019 10:54 and the end date is correctly showing as 9/4/2019 11:45. The true duration is 2.035 days.
The problem happens when the true End Date is less than 24 hours from the start date.
Solved! Go to Solution.
Hi @dkernen,
Sorry for that we put the unnessary screenshot of setting files, we can chang this setting in the panel of power bi desktop after clicking the visual you want to change:
If you use start time and end time columns, we can set the unit to hours and min duration to zero. Then we can change the date type as days to make the x-axis will not be very long.
Best regards,
In the configuration of the object I found that I can put it to Hours and this helps me to measure all the activities of the day
Hi @dkernen ,
Based on my research, the default min duration is set as 1 day in setting.
We can change it to 0 days to fix this problem:
Best regards,
Whoa! Thank you SO much for your research. I am a newbie to Power BI. When you say "we can change it to 0" - what does that mean? Does that mean you can change the visual in the marketplace or does that mean I can create my own custom visual by making the change you note below? I am afraid I do not know how to make my own custom visual (yet!) but I am excited to learn.
Hi @dkernen,
Sorry for that we put the unnessary screenshot of setting files, we can chang this setting in the panel of power bi desktop after clicking the visual you want to change:
If you use start time and end time columns, we can set the unit to hours and min duration to zero. Then we can change the date type as days to make the x-axis will not be very long.
Best regards,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
108 | |
93 | |
70 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |