Hi @ChrisM - I dont believe the current Workload functionality allows for capacity to be set via column and only a hard value across all resources.
There is also an (amazing!) app called Team View, which does a fantastic job of visualizing workload:
However, I believe capacity is used in a similar way.
A different way to look at it and what we have done in the past, is represent utilization per project as a percent. Then using the timeline column associated with the project calculate out the effort based on length of time of the initiative along with it’s associated % utilization. This can then be displayed on the Workload view/widget.
For example, we have a Timeline column Est. Completion (date) and % Util (number) and calculate out the effort with a formula like so (the formula is complex as we may have projects spanning years):
IF(YEAR({Est. Completion}) <> YEAR({Timeline#Start}),(MONTH({Est. Completion})-MONTH({Timeline#Start})+12){% Util},(MONTH({Est. Completion})-MONTH({Timeline#Start})+1){% Util})
We then use this formula column as our effort identifier.
Hope this helps!
Mark