Forecast 'n' past yield within same chart

[Gabrielfranco]

Hi guys, how you doing?

So,  I'm having a hard time trying to figure out how to show a forecast yield data and past yield data within same chart (column/line). I also need to use two diffentes date slicers, one to filter the revenue and other to filter the forecast. 

I tried to follow this example, but it didn't work out as I expected.

https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/

below, an example of what I need to do.

(Spago -  this is the previous BI software that was being used)

[v-chuncz-msft · Accepted solution]

@Gabrielfranco ,

You may drag date from a separate calendar table, apply virtual relationship in DAX measure and then take advantage of Visual level filters.