Hi,
I am tring to created a chart where the X axis is the Months Jan-Dec, Actual batch number for the months Jan to current date in the Column bars and Forcasted batch number in the Y axis as a line. There is one value for each of the months up to October for Actual batch number and one value for each of the months up to December for Forecasted batch. I have created a Date Table and created a relationship between the Date column in the Date table and the Month column in the data table (I also tried connecting Month in both). I set up a Many to One relationship in a single direction and it is active. When I try to plot this with Month from the date table in the X axis, Actual batch number in the Y axis (count) and Forecasted batch number on the secondary Y axis (count) i get a horizontal straight line for the forcasted batches and columns of an equal height all along the X axis. I have tried lots of troubleshoot using copilot by creating measures, checking relationships etc but have had no sucess. Any help would be much appreciated.
