Forum Discussion

arp2's avatar
arp2
Helper II
2 years ago

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)

DisciplineWeekForecastCurrent HeadcountJoinersTerminationsProjected Headcount
Disc12/1/2024              910  10
Disc12/8/2024              910  10
Disc12/15/2024            11102 12
Disc12/22/2024              810 -19
Disc12/29/2024              910  10
Disc13/7/2024            10101 11
Disc13/14/2024              910  10
Disc13/21/2024              810 -19
Disc13/28/2024              910  10
Disc22/1/2024            14151 16
Disc22/8/2024            1315 -114
Disc22/15/2024            1415  15
Disc22/22/2024            16153 18
Disc22/29/2024            1415  15
Disc23/7/2024            1215 -213
Disc23/14/2024            1415  15
Disc23/21/2024            1415  15
Disc23/28/2024            1415  15
Disc32/1/2024            16171 18
Disc32/8/2024            1417 -116
Disc32/15/2024            1517  17
Disc32/22/2024            17172 19
Disc32/29/2024            1517  17
Disc33/7/2024            1417 -116
Disc33/14/2024            1517  17
Disc33/21/2024            1517  17
Disc33/28/2024            1517  17
Total2/1/2024            40                                  42            2                       -                                      44
Total2/8/2024            36                                  42          -                        (2)                                    40
Total2/15/2024            40                                  42            2                       -                                      44
Total2/22/2024            41                                  42            5                      (1)                                    46
Total2/29/2024            38                                  42          -                         -                                      42
Total3/7/2024            36                                  42            1                      (3)                                    40
Total3/14/2024            38                                  42          -                         -                                      42
Total3/21/2024            37                                  42          -                        (1)                                    41
Total3/28/2024            38                                  42          -                         -                                      42

 

 

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community 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

     

    • arp2's avatar
      arp2
      Helper 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.