Actual vs Allocated Hours

here are some examples of what you can do, it also depends if you want to use a custom chart or a default chart , i mostly only use default visuals.

file attached.

Hi NexusProjects ,

You could use Line and Stacked column chart together with Conditional Formatting:

1.calculate the sum of actual time for each client:

Sum Measure = CALCULATE(SUM('Tickets (Actual)'[Time]),FILTER('Tickets (Estimated)','Tickets (Estimated)'[Client]=MAX('Tickets (Actual)'[Client])))

2.If Actual time >AllocatedTime ,then set red color, otherwise green:

color measure = IF([Sum Measure]>MAX('Tickets (Estimated)'[AllocatedTime]),"Red","Green") 

 3.Create visuals:

Below is the final output:

Or you could import more visual types to get a more suitable visual such as Overlapping Bar chart, LipStack column chart as shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.