Thanks for your quick response, I tried your approach and I am now able to show the shift duration as well as the asset duration with dual axis gantt chart. But now I have an additional requirement where I also need to display an alert symbol at the time which it occurred. For an alert my database has entry as for column Type there are 3 entries which are shift, asset usage, alert.
The column Name has entries as s1, s2, s3 for shifts, na for asset and alert for alert notification.
I suppose we need to add a third axis and put alert start time to shapes but the problem is how to synchronize the 3 axis into one ??
Please find the attached workbook with the required format in the attached image down in the same dashboard.
Thanks in advance
I can't think of other ways to add the symbol but dual axis. So I make change to your solution as attached and below screenshot.
It is balance of your requirements.
Hope this helps.
Shift_Asset Gantt (1)_v10.5.twbx 77.0 KB