Add a Budget Line or Bar in Bar Chart

[Amos_Lim]

I have a bar chart with data from the last six months the actual amount spending.

I have another table with the budget amount for this year.

How can I create a chart that includes the upcoming year's budget? either in a line or bar next to the actual amount spent.

Please find the sample file as attached.

Sample Files 

[Amos_Lim]

Thanks, Ritaf1983 for your help and the link. Appreciate.

[Ritaf1983]

@Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @Amos_Lim 
You can create a date table and, create relationships between master and budget by date via this table.

Then you can use a combo graph with the date from the date table on the axis

pbix is attached

more information about the method here :

https://radacad.com/budget-vs-actual-model-in-power-bi-calculations-and-dax

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly