Power BI expense dashboard: categories and variance

A Power BI expense dashboard should compare actual expenses with the approved budget by cost center and category for the same period. Start with dollar variance, explain the categories behind it, and prove that the different views reconcile to the same total.

Microsoft describes a Power BI dashboard as a single page of visualizations, with related reports for details. For an expense review, the useful headline is the spending exception and its owner. Covirage is not affiliated with Microsoft, the maker of Power BI.

Define the expense boundary and budget version

Consider a US business services company reviewing September 2026 expenses for its Operations and Sales cost centers. This example covers travel, supplies, and software only. It is a defined management-review subset, not the company's full operating expense statement.

The ledger export needs a posting period, document ID, cost center, account or category, amount, and currency. The budget file needs the same reporting period, cost center, category, and the approved amount. Preserve the budget version so a revised forecast does not silently replace the original comparison.

Use posted expenses for the actual column. Cash payments can belong to different periods, and open purchase orders are commitments rather than posted expenses. If the review needs either, show it separately. Choose whether credits are signed negative amounts and apply that rule consistently before computing totals.

Summarize actuals and budget separately to cost center, category, and month. Then match those summaries. A monthly budget repeated against every invoice line inflates the budget; multiple budgets matched to the same actual summary inflate actuals. Keep unmatched categories visible until the responsible person resolves them.

The broader dashboard examples show where expenses fit in a cross-functional review. Use the executive dashboard examples when deciding which exceptions warrant leadership attention.

Work the expense variance from the source rows

The table below contains the complete simplified comparison, in USD. The amounts are already aligned to the same month and category definitions.

Expense variance = Actual expense - Budget
Expense variance percentage = (Actual expense - Budget) / Budget

A positive amount is unfavorable under this convention: actual expense exceeded the budget. A negative amount is favorable in the narrow budget sense. It does not prove the business performed better; a postponed purchase can create a favorable variance while delaying work.

With the table in columns A through F, the formulas in E2 and F2 are:

=D2-C2
=IF(C2=0,"",(D2-C2)/C2)

Fill them down through the expense rows. The second formula leaves a percentage blank when the budget is zero. For the total percentage, divide summed variance by summed budget:

=SUM(E2:E5)/SUM(C2:C5)

The result is 5,000 / 60,000 = 8.33%. Percentage figures are displayed to two decimal places; calculations use the underlying amounts. Do not average the row percentages because the budgets differ.

Show cost centers and categories without counting twice

The same rows can answer two different questions. The cost-center view assigns responsibility; the category view explains where spending moved.

Travel is the category driving the overspend: budget is 12,000 + 20,000 = 32,000, and actual expense is 15,000 + 24,000 = 39,000. Its unfavorable variance is $7,000. Supplies and software offset it by $1,500 and $500, so the company check is 7,000 - 1,500 - 500 = 5,000.

The responsibility check is 1,500 + 3,500 = 5,000. Both views reach the same variance because they summarize the same underlying rows. Do not add category totals to cost-center totals; they are two views of the same expenses.

In Excel, Microsoft's SUMIFS function adds amounts that meet multiple criteria. For the original table, the Sales travel actual is:

=SUMIFS(D2:D5,A2:A5,"Sales",B2:B5,"Travel")

That returns $24,000. If you want to prepare a spreadsheet review first, the Excel dashboard guide covers that broader workflow. An operations dashboard addresses the separate question of whether operating output changed along with cost.

Change one input and prove the result

Now change only Sales travel actual expense from $24,000 to $21,000. Every budget amount and every other actual amount stays unchanged. Treat this as a sensitivity example, not a promised saving or an unexplained adjustment to the books.

The changed actual total is 15,000 + 16,500 + 21,000 + 9,500 = 62,000. Subtract the unchanged $60,000 budget to get $2,000 unfavorable, then divide by 60,000 to get 3.33%. The cost-center proof is unchanged Operations variance of $1,500 plus changed Sales variance of $500, again totaling $2,000.

Where it goes wrong

• Mixing expense and cash dates. A payment export cannot automatically stand in for a period expense ledger.
• Replacing the budget mid-review. Comparing actuals against different plan versions hides the original gap.
• Treating blank budgets as zero. A missing mapping needs investigation; a confirmed zero budget is a different fact.
• Reading favorable variance as permanent savings. Delayed invoices and postponed work can move expense to a later month.

The controller owns the ledger tie-out and category mapping. Cost-center managers explain the business reason and expected next-period effect. For the choice of review approach, see Power BI alternatives.

Check your own expense file in Covirage

Bring a sample of your own expense export and approved budget, or a Google Sheet with both clearly labeled. Covirage maps the columns, and its tools compute and check cost-center and category variances; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.

See cost variance analysis for the related review questions.