Power BI - Gantt chart showing asset hire periods. How to create off-hire periods in gantt chart.

Рет қаралды 5,349

Күн бұрын

Power BI - a customised gantt chart shows the dates assets are on hire. The chart is then updated to show the gap periods when the assets are available for hire. The off-hire periods are not in the dataset therefore they are created using a merge, with the available periods then appended to the original dataset. Part of the this process involves resolving the issue of comparing the dates on one line with dates on another.
Timings approximately:
00:00 Introduction
00:28 Explain data
00:50 Create gantt chart with hire periods
04:05 Create hire gap periods (asset available for hire)
06:45 Merge to move data down one row
10:00 Create available start and end dates
12:30 Append queries
17:30 Asset hire period ends one day, new hire period starts the next
20:30 Create available period after the last hire date
#powerbi #ganttchart #powerbitutorial #data #datavisualisation #missingdata #gantt #timeline

Пікірлер: 12

@datalords Жыл бұрын

This is gold. Thanks so much for sharing.

@DFK_data Жыл бұрын

Thank you!

@user-zj3id7yz8e Жыл бұрын

This is really helpful as I am looking for a Gantt Chart for Production Planning.

@DFK_data Жыл бұрын

Thanks! Glad you found the video helpful

@user-dm8dl4ef3v 5 ай бұрын

Thanks for sharing, I was looking for something similar and this concept helped me to solve the problem. Glad to find your channel and lovely explanation.

@DFK_data 5 ай бұрын

Thank you! Glad you found the video helpful.

@kebincui Жыл бұрын

Awesome👍👍

@DFK_data Жыл бұрын

Thank you! Glad you enjoyed the video

@bj1676 Жыл бұрын

Nice work 💎💎💎

@DFK_data Жыл бұрын

Thank you!

@Blackbeard1987 Жыл бұрын

Hello Pauline. Thanks for sharing your instruction! For some reason, I cannot drop my end date in the field provided. Nothing happens. The start date field can be used without any problems. Do you have any idea why this is happening?

@DFK_data Жыл бұрын

Hi, thanks for watching the video. For your question, perhaps worth double checking that the end date's 'Data type' is 'Date'. Otherwise, if you post an example of the issue in Microsoft's Power BI community, maybe someone there may be able to spot the issue from screen prints. Hope this helps.