Blog · Board and management reporting · Finance and FP&A teams
Compare executive layouts for monthly results, cash, and operating exceptions. A worked US company example shows the source rows, calculations, checks, and how a cost change affects the leadership view.
Power BI executive dashboard examples work best when they connect company results with the decisions behind the next management meeting. Compare revenue, operating profit, cash, and delivery against agreed targets, then show the exceptions with owners. The useful example is one a reader can rebuild from the reporting exports, not just a polished arrangement of charts.
The word dashboard has a specific meaning in Power BI. Microsoft describes a dashboard as a single page in the Power BI service, with tiles that lead to underlying reports. Reports can have multiple pages and support filtering and slicing; standard dashboards do not provide dashboard-wide filters.
Use that distinction when discussing these layouts with the person building the view. A fixed company summary can be a dashboard. A page that executives filter by region should be specified as a report page. Neither choice removes the need to check the underlying business figures.
| Layout | Best meeting question | Prominent content | Supporting detail |
|---|---|---|---|
| Monthly company results | Did we deliver the agreed result? | Revenue, profit, actual versus plan | Business-unit contributions and explanations |
| Cash and commitments | Can we meet the next payment commitments? | Closing cash, receipts, payments | Collection exceptions and scheduled outflows |
| Operating exceptions | What needs intervention? | Delivery performance and material exceptions | Affected business unit, owner, and next action |
These are alternative arrangements of the same business records. They are not separate calculation methods. For a broader gallery, see Power BI dashboard examples; the operations dashboard covers the operating audience in more detail.
Lakefield Industrial Services is a fictional US company with Services and Equipment divisions. Its September 2026 management workbook contains the following closed financial amounts and approved revenue plans. Operating expenses include the expenses below gross profit in this management P&L; interest and income taxes are excluded from operating profit.
| Division | Revenue actual (USD) | Revenue plan (USD) | Cost of goods sold (USD) | Operating expenses (USD) | Operating profit (USD) |
|---|---|---|---|---|---|
| Services | 1,600,000 | 1,700,000 | 960,000 | 400,000 | 240,000 |
| Equipment | 2,400,000 | 2,300,000 | 1,800,000 | 360,000 | 240,000 |
| Company | 4,000,000 | 4,000,000 | 2,760,000 | 760,000 | 480,000 |
Operating profit = Revenue − Cost of goods sold − Operating expenses
Operating margin = Operating profit / Revenue
Gross profit is $4,000,000 minus $2,760,000, or $1,240,000. Operating profit is $1,240,000 minus $760,000, or $480,000. Operating margin is $480,000 divided by $4,000,000, or 12.00%. All percentages in this example are rounded to two decimal places after calculation.
Put company revenue and operating profit at the top, with the September period visible. Underneath, place a division comparison showing Services $100,000 below plan and Equipment $100,000 above it. A company revenue card shows that the plan was met; the comparison shows that the composition differed.
Use a small exception table for the explanation. Each comment should refer to a supporting customer, product, or cost record. A division label alone does not prove whether price, volume, timing, or mix caused the movement.
Microsoft's dashboard design guidance recommends designing for the audience, emphasizing important information, and keeping time frames consistent. Here that means showing the company result first and leaving detailed transaction investigation to the supporting view.
Finance supplies this complete cash bridge for September. Opening and closing balances cover the same company bank accounts, and the example assumes no other cash movements or exchange-rate effects.
| Cash item | Amount (USD) | Calculation role |
|---|---|---|
| Opening cash | 650,000 | Starting balance |
| Customer receipts | 3,900,000 | Add |
| Operating payments | 3,200,000 | Subtract |
| Equipment investment | 250,000 | Subtract |
| Debt principal paid | 150,000 | Subtract |
| Closing cash | 950,000 | 650,000 + 3,900,000 − 3,200,000 − 250,000 − 150,000 |
The cash layout puts $950,000 in the headline position and the bridge directly below it. Place collection exceptions and approved payment commitments beside that bridge. Avoid presenting operating profit as money available for payment: receipts include invoices from other periods, while debt principal and equipment payments have different accounting treatment from operating expenses.
Before using the page, reconcile the cash movement total to the bank-account balances. For teams starting with a workbook presentation, the Excel dashboard guide covers that implementation separately.
Operations supplies one row per order due in September, with a complete-and-on-time flag based on the customer commitment. The resulting counts are:
| Division | Orders due | Complete and on time | Delivery rate calculation | Delivery rate |
|---|---|---|---|---|
| Services | 500 | 460 | 460 / 500 | 92.00% |
| Equipment | 800 | 720 | 720 / 800 | 90.00% |
| Company | 1,300 | 1,180 | 1,180 / 1,300 | 90.77% |
The company delivery rate comes from total successful orders divided by total orders due. Do not average the displayed percentages. Define the treatment of customer-requested date changes before classifying orders, and keep the same rule each month.
On an exception layout, show the rate next to the agreed target and put the affected orders below it, with a responsible operations owner. The executive question is whether delivery constraints require capacity, sequencing, or customer-commitment changes. The broader executive dashboard example connects these questions with strategic milestones.
Suppose finance corrects Equipment cost of goods sold from $1,800,000 to $1,920,000. This adds $120,000 of cost; all other inputs stay unchanged. The correction has no September cash effect in this example because payment occurs later.
| Financial measure | Original (USD) | Revised (USD) | Calculation |
|---|---|---|---|
| Company operating profit | 480,000 | 360,000 | 480,000 − 120,000 |
| Rate measure | Original | Revised | Calculation |
|---|---|---|---|
| Company operating margin | 12.00% | 9.00% | 360,000 / 4,000,000 |
| Margin decline | — | 3.00 percentage points | 120,000 / 4,000,000 |
Revenue still meets plan, cash remains $950,000, and the delivery counts do not move. The results layout now directs attention to the corrected cost and the explanation behind it. Keep the correction date and affected period visible so a reviewer can understand why the current page differs from an earlier meeting pack.
Covirage is not affiliated with Microsoft or Power BI.
Bring the P&L, approved plan, cash movement file, and operating export, or a Google Sheet containing the records behind your executive view. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the movements with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for finance teams for the supporting financial reporting context.
Show company results, the largest movements behind them, cash availability, and operating exceptions requiring a decision. Add the reporting period, target, owner, and source cutoff. Choose measures that support leadership action rather than repeating every departmental chart on the same page.
Microsoft distinguishes dashboards from reports. A standard dashboard does not support dashboard-wide filtering or slicing; reports provide filtering and slicing. If the intended executive experience depends on selecting a region or business unit, specify a report page and confirm how users will reach it.
An executive dashboard brings financial results together with operating risks and strategic commitments. A finance dashboard may go deeper into account balances, reconciliations, and cost details. The executive view should show the financial consequence of an exception and identify who can resolve it.
Typical inputs include a closed P&L export, approved budget workbook, cash movement report, and order or service export. Keep the business-unit identifiers and reporting periods consistent. The displayed financial amounts should reconcile to finance's signed-off totals before leadership uses them.