Plotting Calculated Column Months into a stack column chart

Thanks everybody for the replies.

Unfortunately as my data is confidential I am unable to share it. I've created a dummy database in excel as shown here.

Columns A-G are fixed and queried from an online database. Columns H and beyond are my calculated columns done in Power BI,  they display the load of each project at a particular month. A project progresses along stages and naturally the load also changes. My intent is to eventually achieve a Visual where I can filter by the appropriate manager and it shows a timeline of his/her total load per month.

I thought I could separate the monthly loads on another table but I couldn't get it to refer to the main dataset (which contains the project stage for load calculation)

From what I understand from the previous advice, it seems that I need to duplicate 12 entries per Project? Wouldn't that be far too complicated?

Thanks again to all who had replied.