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 Headcoun...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

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
    2 years ago

    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.