One bar chart, change relative data for each variable.

I have a bar chart that is comparing two different things. Lets call it past sales and expected sales.

What I want is for last week and previous, only show past sales (which is how it is by default since sales are 0 in the future), but I wanted expected sales only for the future.

Currently we have pasts and expected sales in the past, and only expected in the future. I was past sales in the past and expected only in the future. So something like a relative date where it is today and one year in the future.

Any advice?