Blog · Board and management reporting
A product dashboard compares sales volume, net revenue, and gross profit on the same product rows. Work through a distributor example, test a rebate change, and reconcile the measures before using them in a business review.
A Power BI product dashboard should compare units, net revenue, and gross margin using the same products and reporting period. The useful result is a product decision: which line needs a price review, which earns profit through volume, and which appears strong only because credits or costs are missing.
The layout comes after the measures. Microsoft defines a Power BI dashboard as a single page of highlights, with related reports providing detail. Keep the summary narrow enough that a sales leader and a finance reviewer can reach the same conclusion from the same rows.
Covirage is not affiliated with Microsoft.
Use an invoice export containing posting date, invoice number, line identifier, product code, quantity, gross sales, and price credits. Bring a corresponding cost export with the same product and period. If the cost already appears on each invoice line, retain that line's cost rather than replacing it with a current catalog cost.
Decide whether the review follows posting month or original sale month. Posting month is easier to reconcile to the ledger; original sale month can help explain the economics of a sale after a later credit. Either approach needs a written rule that stays consistent between periods.
The measures are:
Net revenue = Gross sales − Price credits
Gross profit = Net revenue − Cost of goods sold
Gross margin = Gross profit / Net revenue
Use net revenue per unit only within products sold in comparable units. A case, a single item, and a service hour are different volume measures. The general gross profit margin method explains the cost boundary; here the question is which products explain the result.
An Ohio industrial distributor reviews September 2026. Each product is sold individually, and the credits below are price adjustments with no returned inventory. Costs are already matched to the units sold. All monetary amounts are USD, and margins are rounded to two decimal places after calculation.
| Product | Units | Gross sales (USD) | Price credits (USD) | Net revenue (USD) | COGS (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|---|---|---|
| Pump | 100 | 30,000 | 2,000 | 28,000 | 18,000 | 10,000 | 35.71% |
| Valve | 200 | 24,000 | 0 | 24,000 | 12,000 | 12,000 | 50.00% |
| Filter | 400 | 20,000 | 2,000 | 18,000 | 12,000 | 6,000 | 33.33% |
| Total | 700 | 74,000 | 4,000 | 70,000 | 42,000 | 28,000 | 40.00% |
For the pump, net revenue is 30,000 − 2,000 = $28,000. Gross profit is 28,000 − 18,000 = $10,000, and margin is 10,000 / 28,000 = 35.71%. Its realized revenue per unit is 28,000 / 100 = $280.
The valve earns $12,000 of gross profit, more than the pump despite lower net revenue. The filter sells the most units but contributes the least gross profit. Those are different questions, so show volume, profit dollars, and margin together instead of selecting one universal product ranking.
With the table's input columns in a spreadsheet, net revenue in E2 is =C2-D2, gross profit in G2 is =E2-F2, and margin in H2 is =IF(E2=0,"",G2/E2). Fill down through the products. The total margin is:
=SUM(G2:G4)/SUM(E2:E4)
That produces 28,000 / 70,000 = 40.00%. Retain the unrounded ratios in the underlying calculations.
The sales reconciliation is 74,000 − 4,000 = $70,000. The profit reconciliation is 70,000 − 42,000 = $28,000. Independently summing product profit gives 10,000 + 12,000 + 6,000 = $28,000 as well.
Check the revenue-weighted margin against the margin calculated from totals. Using the exact underlying product margins:
=SUMPRODUCT(E2:E4,H2:H4)/SUM(E2:E4)
This must also return 40.00%. A difference means the row population, formula range, or rounding method changed between the two calculations.
Next reconcile net revenue and COGS separately to the same month's ledger. A matching profit total alone is insufficient: omitted revenue and omitted cost can offset each other. Count unique invoice lines before and after matching costs, too. Repeated cost matches must not multiply a sale.
Now change only the valve's price credits from $0 to $2,400. Its units, gross sales, and COGS remain unchanged. This isolates a commercial adjustment rather than mixing it with a volume change.
| Product | Revised credits (USD) | Revised net revenue (USD) | Unchanged COGS (USD) | Revised gross profit (USD) | Revised margin |
|---|---|---|---|---|---|
| Pump | 2,000 | 28,000 | 18,000 | 10,000 | 35.71% |
| Valve | 2,400 | 21,600 | 12,000 | 9,600 | 44.44% |
| Filter | 2,000 | 18,000 | 12,000 | 6,000 | 33.33% |
| Total | 6,400 | 67,600 | 42,000 | 25,600 | 37.87% |
The proof is direct: net revenue falls by $2,400 and unchanged costs make gross profit fall by the same $2,400. Total margin becomes 25,600 / 67,600 = 37.87%, a decline of 2.13 percentage points from 40.00%. Physical volume is still 700 units.
The valve still has the highest margin, but it no longer has the highest gross profit dollars. Finance should confirm the rebate period; the product owner should review the commercial terms before reading the change as weaker demand.
Put net revenue, gross profit, and gross margin across the top. Below them, use a product comparison table showing units, credits, and costs. Microsoft describes Power BI tables as suitable for comparing exact values and multiple measures, which fits this reconciliation task.
Keep a short exception list beside the table: missing costs, unmatched credits, and products with zero revenue. The wider Power BI dashboard examples cover other business layouts. A Power BI executive dashboard can summarize the approved product findings without repeating the whole product table.
Bring your invoice lines, product credits, and matched costs as a file or Google Sheet. Covirage maps the columns; its tools compute and check product revenue, volume, and margin, while the external AI model explains the results 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 revenue driver analysis for the supporting business use case.
Include product identifiers, units sold, net revenue after credits, matched cost of goods sold, gross profit, and gross margin. Show the reporting period and cost policy beside them. Add a product comparison table so the total can be traced to individual lines.
Calculate the overall margin by dividing summed gross profit by summed net revenue. A simple average gives a small product the same influence as a large one. Revenue weighting produces the same result as dividing the totals.
Keep returns and credits tied to the original product and document their reporting period. Separate revenue credits from returned units and cost reversals. A price adjustment changes revenue without necessarily changing either physical volume or cost of goods sold.