Chart filtered for last two weeks and next two weeks

[Anonymous]

I am looking to create a line chart which shows the orders delivered for a each store for the last two weeks as well as a dotted line showing theexpected sales for the next two weeks (which is based on an estimated delivery date measure). How would I do this?

[Anonymous]

I am actually looking for something like this.

I found this in another thread, but it doesn't really specify how it is done. The only way I can think of this working is this:

Remove the attribute from the legend, and instead create separate measure filtering for each value in that attribute. And for each value, create two measures, one with an if condition filtering for two weeks in the past and one with an if condition filtering for the next two weeks. Then for each, set one of the measures as a solid line and one as a dotted line.

Is this the best way to do it or is there a more simple way?

[v-chuncz-msft]

@Anonymous,

You may try using IF Function to add two measures.