Forum Discussion
Resource Allocation Model with Multiple Gates and Durations
Hi MDS20,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar
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