Blog · Board and management reporting
Power BI dashboard best practices start with the business decision and reconciled source measures. Use a worked monthly review, exact spreadsheet formulas and checks that keep the discussion tied to evidence.
Best practices for a Power BI dashboard begin with a decision and source figures that reconcile. Agree on what the review should change, check the exports behind each KPI, and show the exceptions that need an owner. Chart formatting comes after those choices.
Microsoft's dashboard design guidance recommends designing for the audience and keeping the essential story on one screen. The business work is deciding which measures deserve that space. Covirage is not affiliated with Microsoft or Power BI.
A monthly distributor review might decide where the sales director should intervene and which service issue needs operations support. That requires revenue against target, gross margin and on-time delivery. Website visits would add little unless the same meeting controls customer acquisition.
Write a short definition beside each proposed measure:
| Measure | Population and calculation | Decision owner |
|---|---|---|
| Net revenue | Posted sales less credits for the review month | Sales director |
| Gross margin | Net revenue less the corresponding cost, divided by net revenue | Finance lead |
| On-time delivery | Deliveries meeting the agreed promise date divided by completed deliveries | Operations lead |
State whether service is measured by order, shipment or order line. A denominator that changes midway through the year makes the trend unusable. Give every measure a source file, period, cutoff and named approver.
The layout for an executive review differs from a shift review. Use executive dashboard examples for leadership questions and operations dashboards for operating exceptions; do not make one page carry both meetings.
Consider a US distributor's September 2026 review. Finance supplies revenue, cost and target by division; operations supplies completed and on-time deliveries for the same month. Keep these populations separate while checking them, then place their grouped totals together.
Use columns A through F for this worksheet. Monetary amounts are whole dollars, and the delivery counts are whole completed shipments.
| Division | Revenue (USD) | Cost of goods sold (USD) | Revenue target (USD) | Completed deliveries | On-time deliveries |
|---|---|---|---|---|---|
| Central | 520,000 | 338,000 | 540,000 | 200 | 188 |
| West | 310,000 | 201,500 | 300,000 | 125 | 112 |
| East | 170,000 | 127,500 | 160,000 | 75 | 71 |
| Total | 1,000,000 | 667,000 | 1,000,000 | 400 | 371 |
If the underlying sales sheet named Raw has division in A, posting period in B and net revenue in C, rebuild a division's revenue in B2 with:
=SUMIFS(Raw!$C$2:$C$10000,Raw!$A$2:$A$10000,$A2,Raw!$B$2:$B$10000,"2026-09")
Extend the ranges to cover the complete export. This follows Microsoft's SUMIFS syntax: sum a range only where all specified conditions hold. Build each source total independently before placing it beside another file's totals.
In the summary worksheet, enter gross profit in G2, gross margin in H2, revenue variance in I2 and on-time rate in J2:
G2: =B2-C2
H2: =IF(B2=0,"",G2/B2)
I2: =B2-D2
J2: =IF(E2=0,"",F2/E2)
The text before each formula identifies its destination cell. Paste from the equals sign and fill down through row 4. Format H and J as percentages with one decimal place; keep full precision in the cells.
| Division | Gross profit (USD) | Gross margin | Revenue variance (USD) | On-time rate |
|---|---|---|---|---|
| Central | 182,000 | 35.0% | -20,000 | 94.0% |
| West | 108,500 | 35.0% | 10,000 | 89.6% |
| East | 42,500 | 25.0% | 10,000 | 94.7% |
| Total | 333,000 | 33.3% | 0 | 92.8% |
For the total rates, divide totals rather than averaging division percentages:
H5: =SUM(G2:G4)/SUM(B2:B4)
J5: =SUM(F2:F4)/SUM(E2:E4)
The company margin is 333,000 / 1,000,000 = 33.3%. The on-time rate is 371 / 400 = 92.75%, displayed as 92.8%. See gross profit margin for the definition and cost-policy boundaries.
Revenue less cost must equal gross profit: 1,000,000 - 667,000 = 333,000. The sum of the division variances must equal the company variance: -20,000 + 10,000 + 10,000 = 0. The delivery numerator must not exceed its denominator for any division.
Tie revenue and cost independently to the finance export's control totals. Tie completed deliveries to the scoped shipping register. If an unassigned division exists, display it during validation rather than dropping it from the grouped table. A page that excludes unmatched records can look internally consistent while missing part of the business.
The total revenue meets target, but Central is below its target. West has the lowest service rate, while East has the lowest margin. Those are different questions for different owners; a single company status would conceal them.
Put the decision measures first and the material division exceptions immediately beneath them. Label September 2026, USD, the shipment definition and the export cutoff. Show the target beside the actual, and use the same precision throughout the page.
For each exception, record the question to investigate, the owner and the next review date. Central's sales manager should explain the revenue gap. West's operations manager should inspect late deliveries. East's finance partner should separate price, cost and product mix before recommending action.
If the immediate job is answering a question from a workbook, the Power BI alternatives guide explains the choices without turning this review checklist into a product comparison.
Bring the revenue workbook, delivery export and KPI definitions in a file or Google Sheet. Covirage maps the columns; its tools compute and check the measures, and 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 a sample of your own data.
See how this supports self-service analytics.
Choose the measures needed for the decisions in that review. A monthly commercial review might need revenue, margin and service performance, with supporting exceptions. Remove a measure if no attendee can explain what action would change when it moves.
Show the company total with the units responsible for material differences. A total can meet target while one division misses it. Keep the overview concise and retain a supporting breakdown so the reviewer can connect the total to an accountable manager.
The business owner should approve the meaning and decision threshold, while finance or the source owner approves the input population and reconciliation. Record the agreed definition, period and exclusions with the review so a later change does not silently rewrite the comparison.