Weekly Forecast and capcity Chart

[arp2]

I have a table showing multiple disciplines names, week date and number of employees in discipline for that week. I want to plot this in secondary Y Axis in column line combo chart but it’s summing the data for all weeks and shows a straight line (that summed number for all weeks in the plot). Any suggestions plz

[Greg_Deckler]

@arp2 Generally this means that there is a missing relationshp in the model.

[arp2]

DummyDataTable1 2Feb.xlsx

The dummy PBI file is available at following link.

https://1drv.ms/u/s!Ag_LqrJ6gGmfllbA6ZrdJLdiGkQL?e=WEvQwb

@Greg_Deckler 

What's happening is, when I add Capacity/Projected Capacity to secondary Y axis, it is summing the value for selected discipline for all weeks in table and showing flat line (summed number) whereas I want weekly number in the chart

[Greg_Deckler]

@arp2 Right and I'm saying that is generally because there is a missing relationship between 2 tables and thus all of the rows in that second table are in context versus being filtered to the correct rows via the relationship.

[arp2]

@Greg_Deckler Got that! I tried but I am unable to solve it. Can you plz have a look at PBI dummy? https://1drv.ms/u/s!Ag_LqrJ6gGmfllbA6ZrdJLdiGkQL?e=WEvQwb

[Greg_Deckler · Accepted solution]

@arp2 Updated your PBIX, attached below signature. Your Week to Week relationship is inactive so you need to use USERELATIONSHIP in a measure.

Projected Capacity Measure = CALCULATE(SUM('Table2'[Projected Capacity]), USERELATIONSHIP(Table1[Week], 'Table2'[Week]))

[arp2]

@Greg_Deckler This solved the issue and thank you very much for the help.