Budget and Actuals column graphic

[Anonymous]

I have been trying to create column graphic includes Actual 22 and Budget 22 as values.

Budget values should be dashed line values like below picture and data label shows all values and Actual 22 values would be column. I could not do it. Do you know how I can do it the graphic like below. I could not find this format at google. 

[jdbuchanan71 · Accepted solution]

@Anonymous 

You can get very close with a Line and Stacked Column chart.  Put the budget on the line and set the Stroke Width to 0 then turn on markers.

  

[Anonymous]

Thank you so much, I did it but I do not have line and stroke with part:( why? I just have following part.

[dhruvinushah]

Hi @Anonymous , 
This can be done. 
Assuming you have a transaction table containing your transactions or Actuals amount with their transaction date associated to the same. 
Next you have a budget table containing your budget amounts with the date associated to the amount as well. 

Next you have a date/calendar table that has relationships set up in the data model to your Transaction and Budget tables on their respective date columns. 

Now, on to your chart visual: 
Use the Date: Month from the Calendar Table on the x-axis. Use the Budget Amount from Budget table for the line axis, and Actuals Amount from the Transaction table on the column axis. 
The aggregations for the Actuals and Budget amounts would be SUM (if itsn't already summing up by default). 
You can set the nature of the Budget line to be dashed in the format pane of the visual. 
You can also change the position of what totals and data labels are shown / visible from the format pane. 

Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!

[Anonymous]

Unfortunately it does not work. I need the line as horizontal:(