Forum Discussion
Capacity count per week
I have to present a chart showing forecast headcount per week (stacked column) and I want to show two lines in the secondary y-axis (1) Current Headcount and (2) Projected Headcount. Current Headcount should show a constant number throughout all weeks whereas Projected Headcount should be a projection for each week based on the net of new joiners & terminations in each week.
Can you plz guide me?
The sample Table and desired visuals are pasted here below (charts are below the table)
| Discipline | Week | Forecast | Current Headcount | Joiners | Terminations | Projected Headcount |
| Disc1 | 2/1/2024 | 9 | 10 | 10 | ||
| Disc1 | 2/8/2024 | 9 | 10 | 10 | ||
| Disc1 | 2/15/2024 | 11 | 10 | 2 | 12 | |
| Disc1 | 2/22/2024 | 8 | 10 | -1 | 9 | |
| Disc1 | 2/29/2024 | 9 | 10 | 10 | ||
| Disc1 | 3/7/2024 | 10 | 10 | 1 | 11 | |
| Disc1 | 3/14/2024 | 9 | 10 | 10 | ||
| Disc1 | 3/21/2024 | 8 | 10 | -1 | 9 | |
| Disc1 | 3/28/2024 | 9 | 10 | 10 | ||
| Disc2 | 2/1/2024 | 14 | 15 | 1 | 16 | |
| Disc2 | 2/8/2024 | 13 | 15 | -1 | 14 | |
| Disc2 | 2/15/2024 | 14 | 15 | 15 | ||
| Disc2 | 2/22/2024 | 16 | 15 | 3 | 18 | |
| Disc2 | 2/29/2024 | 14 | 15 | 15 | ||
| Disc2 | 3/7/2024 | 12 | 15 | -2 | 13 | |
| Disc2 | 3/14/2024 | 14 | 15 | 15 | ||
| Disc2 | 3/21/2024 | 14 | 15 | 15 | ||
| Disc2 | 3/28/2024 | 14 | 15 | 15 | ||
| Disc3 | 2/1/2024 | 16 | 17 | 1 | 18 | |
| Disc3 | 2/8/2024 | 14 | 17 | -1 | 16 | |
| Disc3 | 2/15/2024 | 15 | 17 | 17 | ||
| Disc3 | 2/22/2024 | 17 | 17 | 2 | 19 | |
| Disc3 | 2/29/2024 | 15 | 17 | 17 | ||
| Disc3 | 3/7/2024 | 14 | 17 | -1 | 16 | |
| Disc3 | 3/14/2024 | 15 | 17 | 17 | ||
| Disc3 | 3/21/2024 | 15 | 17 | 17 | ||
| Disc3 | 3/28/2024 | 15 | 17 | 17 | ||
| Total | 2/1/2024 | 40 | 42 | 2 | - | 44 |
| Total | 2/8/2024 | 36 | 42 | - | (2) | 40 |
| Total | 2/15/2024 | 40 | 42 | 2 | - | 44 |
| Total | 2/22/2024 | 41 | 42 | 5 | (1) | 46 |
| Total | 2/29/2024 | 38 | 42 | - | - | 42 |
| Total | 3/7/2024 | 36 | 42 | 1 | (3) | 40 |
| Total | 3/14/2024 | 38 | 42 | - | - | 42 |
| Total | 3/21/2024 | 37 | 42 | - | (1) | 41 |
| Total | 3/28/2024 | 38 | 42 | - | - | 42 |
3 Replies
- arp2Helper II
- PijushRoyCommunity Champion
Hi arp2
I am not sure what is the issue you are facing
Are you looking for DAX calculation or your data is ready (as you shared) only you looking for visuals?
Please confirm
Look into the pbix file if only looking for visual
https://drive.google.com/file/d/1FVvtR2kpzsfHcmNn_ppJBW5pt6ROGrFL/view?usp=sharing
If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush- arp2Helper II
Thanks for reply. I have a table that shows count of employees in each discipline for 6-7 months period (by week). Let's say one discipline (named Disc1) has 910 employees as of week ending 2nd Feb. With turnover (new jonees as well as people leaving) next few weeks are listed with Projected Headcount. When I add the current Headcount and Projected Headcount to secondary Y-axis, the chart shows either sum of all weeks or count of all weeks based on selection in formatting. I want to show the number for each individual week in the chart.