Forum Discussion
Showing % utilization of a resource
Hi, I've a fixed Excel template which is populated as per the below. Once imported into Power BI I'm trying to show utilization per enigneer for each month/quarter (or whatever period is filtered.) ...
MFelix
Super User
Super UserHi Mrooney,
As I can understand you want to find the percentage per month / resource in the visuals you can chose the option quick calc on the value instead of the sum or count, this gives the option to calculate over total, grand total,...
If you have every values time / resource on your visual it gives what you want, you then can add a trend line wuth fixed value 80%and see who is off.
Regards
MFelix
As I can understand you want to find the percentage per month / resource in the visuals you can chose the option quick calc on the value instead of the sum or count, this gives the option to calculate over total, grand total,...
If you have every values time / resource on your visual it gives what you want, you then can add a trend line wuth fixed value 80%and see who is off.
Regards
MFelix