Forum Discussion
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)
You may drag date from a separate calendar table, apply virtual relationship in DAX measure and then take advantage of Visual level filters.
1 Reply
- v-chuncz-msftCommunity Support
You may drag date from a separate calendar table, apply virtual relationship in DAX measure and then take advantage of Visual level filters.