Forum Discussion
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 year's budget? either in a line or bar next to the actual amount spent.
Please find the sample file as attached.
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
3 Replies
Amos_LimThanks, Ritaf1983 for your help and the link. Appreciate.
- Ritaf1983
Super User
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