Simple Gantt duration issue

[Andy18831]

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

 

 

 

 

[v-yilong-msft · Accepted solution]

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.

[miTutorials]

I want to suggest an alternative Gantt visual which is available and really clean - Do give it a try!

Step by Step Tutorial to Create Gantt Chart in Power BI using Deneb | MiTutorials - YouTube