Forum Discussion
Resource utilization per day
Heya,
You can use a matrix visual and plot a date-table as the columns. Linked to the orignal table. Then plot users on rows and task would be value in this case.
Then you can use conditional formatting to create colors for projects.
Goodluck.
Heya,
You can use a matrix visual and plot a date-table as the columns. Linked to the orignal table. Then plot users on rows and task would be value in this case.
Then you can use conditional formatting to create colors for projects.
Goodluck.
Thats a great idea, but how to handle the "end dates"?
For exemple some tasks might start at 10/02/2020 and end at 12/02/2020.
Also how can i handle the blank dates? i need them to appear to.
Thanks a lot!!!
Hi joaoantunes ,
I think Gantt chart can help you. Please reference the blogs and videos:
GANTT chart visuals in Power BI
Create A Gantt Chart In Power BI With A Matrix Visual
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello!
Thanks for the idea. i've tested that and 2 more Gantt solutions that are avaliable on the PowerBi Marketplace.
The problem with that one you've sended (its my favorite btw) its that it doesn't say the week days on the top line.
It should have like monday, thuesday...
Is it possible on that Gantt? if yes, how?
Thanks
