Gantt chart using only seconds data

I have to create gantt chart where my start and end are just seconds. There is no date. I need to plot the start and end of a task in seconds. I would prefer the Gantt visual to use the one that Micr...

General Comment

Need Help

Show and Tell

Tutorial Requests

Anonymous
1 year ago
Hi, priteshb

As you have noted, the current offerings from Microsoft may not fully achieve the ideal third-party visualisation results you are aiming for. However, it is possible to achieve the following results:

1.Please note that the start date and end date fields need to be of the datetime type. It is recommended to use the TIME() function for conversion:

startdate = TIME(0,0,'Table'[start])
enddate = TIME(0,0,'Table'[end])

Here is a detailed description of the data required for this visualisation:

2.Secondly, regarding the issue of not being able to include Duration, based on my testing and understanding, it is due to the end date already having content, causing a conflict between the two.

3.Lastly, for your visualisation, I suggest that when you change the time type to seconds, you also adjust the parameters in the following position. This will make your visual object more aesthetically pleasing.

Please find the attached pbix relevant to the case.

Of course, if you have any new ideas, you are welcome to contact us.

Best Regards,

Leroy Lu

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

priteshb

Frequent Visitor

1 year ago

This is exactly what I was looking for. Would have been nice if the data type = second could have customisable axis lengths. But minutes will do for now. Thank you Anonymous. I marked your answer as an accepted solution.

One additional question: How do I get each of the tones to show different colors? I added tone as legend but it does not differentiate each tone to different colors.