Forum Discussion
Amos_Lim
Resolver I
Resolver IAdd a Budget Line or Bar in Bar Chart
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 ye...
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
