Waterfall Forecast vs Actual

[akolodz2]

My organization has recently explored the possibilities of Power BI to help streamline quarterly reporting. Typically we utilize a waterfall chart which is manually input. I am trying to bridge an investment category between the 2019 Q1 Forecast and the 2019 Q1 Actuals. The measures are as followed from left to right which I would be using for the upcomming quarter close:

2018 Q1 Actuals, 2019 Q1 Forecast, Investment category bridge (forecast vs actual), 2019 Q1 Actuals.

Is it possible to achieve this scenario in PowerBI? Essentially Im looking to show last years figures, this years forecast and bridge it to this years actuals. Thank you

[v-cherch-msft]

Hi @akolodz2 

It is possible.You may create measures.Please check if this post could help you.If it is not your case,please refer to How to Get Your Question Answered Quickly to post your sample data and expected output.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie