Skip to content
finreportKit
All guides

Analyze budget variance in Power BI

Use a budget variance matrix to identify material differences, interpret expense and revenue movements, and drill through to transactions.

finreportKit Variance analysis 4 min read
Email guide

Build a variance matrix for month-end review

Start with the reporting month and department. Use accounts as rows and put Budget, Actual, Variance, and Variance % side by side. Sort by the size of the dollar variance when deciding which accounts to investigate first. Use the percentage to understand the size of the change relative to the budget.

  1. Calculate dollar variance as Actual minus Budget when both values exist.
  2. Calculate the rate as DIVIDE([Variance], ABS([Budget])) in DAX and format it as a percentage. Keep it blank if the budget is zero or missing.
  3. Add an account type to interpret the direction. With positive amounts for revenue and for expenses, a positive revenue variance is favorable and a positive expense variance is unfavorable.
  4. Label favorable and unfavorable in text and use color to reinforce the label.

Trace a difference to its source

Set the sample month to April 2026 and open Marketing / Campaigns. Actual expense is $12,000 against a $10,000 budget, so the row is $2,000 unfavorable (+20%). The April 8 entry (TX-0403) is $5,000 and the April 21 entry (TX-0404) is $7,000. Add both to check the reported actual.

In Power BI Desktop, add a transaction detail page with the date, line ID, account, and amount. Set a drillthrough field such as Account and carry the current month and department filters into the detail page. Check that the rows roll up to the matrix value under the same filters.

Write an explanation you can verify

Begin with the period, account, actual, budget, and the dollar variance. Use the transaction descriptions, invoice references, and the original budget assumptions to decide whether the gap reflects timing, a price change, volume, or a coding error. If you only have the amount and supplier, record the gap and keep the cause open until you confirm it.

For example, a month-end note could record that April campaign expense was $12,000, or $2,000 over budget. The ledger lines tie to the report. The owner is checking whether April included an invoice that was planned for May.

Try this with the sample report

Use the same budget and transaction files to check the April Marketing results.

References