Want to see a one line chart for two different hour distribution columns

[je__]

Hi,

Currntly I am working on making monthly hour distribution for a project. The project has many items and each item has different budget hours and start/end date. 

Project number	Category	Budget hour	Project start	Project end
A12345	A	119	3/1/2024	1/1/2026
A12345	B	295	6/1/2024	1/1/2026
A12345	C	200	2/1/2025	5/1/2026

As I want to make different hour distribution by periods, I added middle period by using start/end date.

Middle = If(Proejct[Category]="A",EDATE(Project[Project start],4),If(Proejct[Category]="B",EDATE(Project[Project start],3),IF(Proejct[Category]="C",EDATE(Project[Project start],6)))

Project number	Category	Budget hour	Project start	Middle	Project end
A12345	A	119	3/1/2024	7/1/2024	1/1/2026
A12345	B	295	6/1/2024	9/1/2024	1/1/2026
A12345	C	200	2/1/2025	8/1/2025	5/1/2026

Based on the above table, I want to distribuet budget hours.

1) From Project start to Middle, I want to distribute certain % of budget hours. In case of "A",  30% of budget distribution for those period. For "B", 40% of budget and 20% of budget in case of "C"

2) From Middle to Project end, I wast to distribute the remaining budget hours. 

3) Finally I want to see all budget distribution in one graph.

As I have much longer list, I would like to know how I could make query or new column.

Your support would be really appreciated!

[lbendlin]

sounds good.  Please provide sample data that fully covers your issue - including the weighting.
Please show the expected outcome based on the sample data you provided.  How would your graph look like?

[je__]

Dear Ibendlin,

Thank you for the message.

I attached one PBI for your reference. When you see the graph in the attachement, it is something that I would like to see but it is not perfect. For Y-asix, I also want to add 'Budget/Middle to End' so that it shows overall distribution by month and different budget hours. 

I would appreciate if you let let me know.

Thank you so much!

[lbendlin · Accepted solution]

Your calendar table needs to be contiguous. But you also need to indicate business days unless you want to distribute the hours across all days.

It may make sense to split your periods

From

to 

[je__]

Hi,

It works now! Thank you for your great idea!