Forum Discussion
Add a Budget Line or Bar in Bar Chart
- 2 years ago
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
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