How to show past and future data together in the chart

[#1]

Can any body please look into this and help,

I have two measures, i am showing the data by month,

if user select past dates till today is should show one measure, if user selects future dates it should show another measure.

in single chart

Please help

Thanks in advance

[#2]

Hello Venkat,

I got the measures, i understand the logic even, this works only for the year, what if user select the month,

for example if you select September, half data is from one measure, another half data from second measure.

please help

[#3]

Hello Venkat,

Please look into the sample qvw file, i have year, and two charts from two different source,

PAST chart having only the data for past months ( for current month till date)

PAST and FUTURE chart having past month, current month and future month.

i need to create a chart with past data(Source1.Revenue). from past month, future data from past and future chart(Source2.Revenue).

if you select 2014 the chart shouls have three bars, combining past and future

Hope it is clear

Thanks