Forum Discussion

Gabrielfranco's avatar
Gabrielfranco
Frequent Visitor
7 years ago
Solved

Forecast 'n' past yield within same chart

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)