Resource Allocation Model with Multiple Gates and Durations

Hi MDS20,

Thanks for reaching out to the Microsoft Fabric Forum Community.

To create a stacked bar chart in Power BI showing each lead’s percent allocation per month, you’ll need to Transform data. Here's how you can approach it.

1. Unpivot D0 to D5 columns in Power Query, so each phase becomes a row instead of a set of columns. This makes the data easier to work with.

2. Since each phase has a start and end date, you’ll want to expand these rows to include each individual day the lead is working on the project.

3. Create a date/calendar table in your model with columns like Date, Month, and Year. You’ll need this to summarize data by month.

4. Make sure the daily allocation table is connected to the calendar table through the date column. You can also connect it to a Lead table if you want better filtering.

If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.

Best regards,
Prasanna Kumar

Hi MDS20,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful — this will benefit others in the community as well.

Best regards,

Prasanna Kumar

Anonymous , the solution works given the sample data provided, thanks! I have since had to pivot from the source data and structure so I've had to take a different approach.