Forum Discussion
Budgeted vs Actual Chart
Hi guys,
How do a budgeted vs actual chart in MS Power BI?
| Cost Center | Budgeted | Actual |
| CONT ADM | 1.920.149,21 | 765.569,81 |
| CONT JUD | 998.774,90 | 197.763,18 |
| CONS TRIB | 2.358.777,92 | 347.716,09 |
| SOCIETÁRIO | 1.858.711,21 | 293.110,47 |
| Total | 7.136.413,24 | 1.604.159,55 |
In Excel, I was a custom combination, however, I dont know how in MS Power BI.
3 Replies
- ankitpatira
Community Champion
Luciano You can use stacked column or bar chart which will be the closest to what you've got in excel. but you can also use other visuals. all you need to do for stacked column or bar chart is to drop actual and budget fields under Values section.
ankitpatira The problem is that this way the bars are added. Ideally, they overlap, so that is possible to analyze how much of the budgeted has been spent.
Hi Luciano,
You can create a column chart using your data, turn on Data labels as shown in the following screenshot, this way, Budgeted values and Actual values will stand side by side in the chart, which is easy for you to view.
If the above chart doesn’t satisfy your requirement, please describe more details about your expected result.Thanks,
Lydia Zhang
