Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
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.
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.
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |