Forum Discussion

Andy18831's avatar
Andy18831
New Member
2 years ago
Solved

Simple Gantt duration issue

Hi team

 

We are upgrading our IT and setting up a Gantt to report to the business.  Seems simple, using the free Gantt in BI.

Set up a sheet with some dummy data.  Piece of cake, right?!

 

Everything though, is coming up as 1 day duration.  it does not matter if I use the end date or duration.

 

The line I have indicated is is 46 days in duration however, it only shows as 1 day.  I can see the data field is set to "count" so I guess that is right as there is 1 thing to count but how do I get it to display the days required.

Or how to I get the end date to work?  Getting the same issue there to but it is lfirst or last date, or count.  Again, doesnt work.

 

Hoping for someone can assist

 

cheers

 

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Andy18831 ,

    I think you can use this Gantt 3.0.12.0 visual.

    I create a table as you mentioned.

    Then I add it to the Gantt visual.

    I also create a calculated column to calculate the duration and put it into the tooltip.

    Duration = DATEDIFF('Table'[Start Date],'Table'[End Date], DAY)

     

     

     

    Best Regards

    Yilong Zhou

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

2 Replies