Forum Discussion
Gantt Chart Weekends
Hi,
I am currently using the Power BI standard Gantt chart visual. I am using a start day with an allocated time against this task.
For example
Task - 1
Start Date - 01/01/2021
Duration - 6 Days
I want to display this task in the Gantt chart but exclude the weekends. For example, if a task was 6 days long and started on the Monday, I would require it to finish on the Monday instead of the recommended Saturday.
Any help or work around on this matter?
Many thanks,
E
Hi Anonymous
Try Days off function in gantt chart. Set First day of week as Sunday.
Gantt visual:
2021/01/02 - 2021/01/03 and 2021/01/09 - 2021/01/10 are weekends.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , I have code that can help you to calculate end date based working days.
Not very sure if that you can use in your visual
Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766 Hi Anonymous
Try Days off function in gantt chart. Set First day of week as Sunday.
Gantt visual:
2021/01/02 - 2021/01/03 and 2021/01/09 - 2021/01/10 are weekends.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
