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.
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
Do you have a date table in Power BI? if not you should add it and you will be able to show day names etc on the chart.
Hi joaoantunes ,
After trying a few times, I think it is not possible in Gantt chart to display days of the week in axis. Sorry for that. If you really need to show them, maybe you could create a custom axis using text box manually. I get the idea from the vedio: Create A Gantt Chart In Power BI With A Matrix Visual. He created a Gantt chart with Matrix visual. The time axis on the visual is what he created manually.
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.
Hi joaoantunes ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.
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.