Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to figure out the best way to depict staff utilisation report that shows staff name, project name and utilisation visual that depicts the percentage of staff utilisation per period. Ideally, the utilisation should be visualised as a bar on calendar.
The data table looks like this:
Name Project Start End Utilisation
John Doe Project1 20170101 20170331 75
John Foe Project 2 20161115 20170226 100
The utilisation should be ideally depicted as in the picture (Excel screenshot) below. Any ideas, advise?
Thanks,
Solved! Go to Solution.
I would try Matrix as visual, dates as column, employees as rows and values would be conditional formatted.
Or try to Gantt visual from Custom gallery.
Regards.
Pavel
I would try Matrix as visual, dates as column, employees as rows and values would be conditional formatted.
Or try to Gantt visual from Custom gallery.
Regards.
Pavel
Great, that worked well (the matrix). I have created a dimensional table with dates and an additional table to expand periods, then used the matrix with conditional formatting as suggested and that worked really well. Thanks.
Yes, that's it. You are welcome.
Pavel
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |