Forum Discussion
Operational Capacity Chart from Only Capacity Start Date
I need to make an operational capacity chart (stacked line or stacked column) that shows current cumulative capacity by date.
The issue is, I only have the start date which that capacity comes online, therefore the capcity shows only on the start date and does not continue to "stick" for the rest of the forecast after the start date.
This seems like some sort of operation with a date table and a merge, but I cannot get it. Any help would be much appreciated
Example of Data as Received
Current Result (capacity only on start date)Desired Result - Capacity continues after the start date
I was able to solve this in power Query using the Pivot and Fill-Down Functions.
The process is as follows:
0. Make sure your only columns in the table are [Start Date] [Project Name] and [Capacity]
1. Pivot [Project Name] using [capacity] as the values
2. Transform -> Fill -> Down
3. Select [Start Date] then Unpivot -> other columns
5 Replies
Hi wifc5013 ,
Which type of chart did you want to use ? I didn't find your "result chart" in powerbi visual. So if possible, could you please inform me your chart name? If you want to get cumulative value based on month, you also could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zoe,
The output chart I am looking for is called 'area chart'
Thanks!
I was able to solve this in power Query using the Pivot and Fill-Down Functions.
The process is as follows:
0. Make sure your only columns in the table are [Start Date] [Project Name] and [Capacity]
1. Pivot [Project Name] using [capacity] as the values
2. Transform -> Fill -> Down
3. Select [Start Date] then Unpivot -> other columns
