Chart recommendation for forecast, actual, and difference measures

[Anonymous]

I have a bar and line chart that is showing the change in monthly forecast by week, with a line that has the actual total amount for the period the forecasts are for. On top of this, I need to show the % difference between the monthly actual compared to each forecast (purple text). I'm struggling to find a good visual/chart to show this clearly. Ideas?

[amitchandak]

@Anonymous , Make sure you have date table , the create a measure like

This month Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date]),0))

This month Forecast = CALCULATE(SUM(Forecast[Forecast Amount]),DATESMTD(ENDOFMONTH('Date'[Date]),0))

Diff %  =([This month Sales] -[This month Forecast],[This month Forecast]) //Change as per need

or like this

Month Rank = RANKX(all('Date'),'Date'[Month Start date],,ASC,Dense) 
This Month = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Month Rank]=max('Date'[Month Rank])))

In your case You can use month year in case of Rank, That should also work

Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

[Greg_Deckler]

@Anonymous - Maybe add the percent difference as an additional value to your column chart so that you get 2 columns per?