How to create a dashboard in Power BI for business KPIs

To create a dashboard in Power BI, first define and reconcile the business measures, then build report visuals and pin the checked results to a dashboard in the Power BI service. The review should show both the headline result and the rows that explain it. A revenue tile is useful only when its period, scope, and relationship to target are clear.

Start with the decision and the right artifact

Write the review question before choosing a chart. For a US distributor's monthly sales meeting, it might be: did each region deliver its revenue target without sacrificing gross margin? That question requires revenue, cost of goods sold, approved targets, and a region field that is consistent across the files.

Microsoft describes a dashboard as a single page of highlights, with related reports holding the detail; dashboards are a feature of the Power BI service. Keep that dashboard and report distinction clear when you scope the work. The broader business dashboard workflow covers how to connect a review question to measures across reporting approaches.

Assign the sales leader to explain performance and finance to approve the revenue and cost definitions. Agree whether returns reduce the sale in the reporting month or are assigned to an earlier period. Save those choices alongside the review pack so a future movement does not turn out to be a definition change.

Step 1: take a controlled export

Use an invoice-line export with invoice ID, line ID, posting date, region, net revenue, and cost of goods sold. Keep credit memos as signed amounts under the approved policy. Take targets from the approved monthly target file, with one record for each region and period.

Retain the source files and their extraction dates. Check the date range, currency, and included entities before summarizing anything. If invoice IDs repeat legitimately across lines, use the invoice-and-line combination to identify a row. Removing repeated invoice IDs alone would delete valid sales.

Prepare a separate review table with one row per region. Aggregate sales and costs first, then attach each region's target once. Repeating a monthly target on every invoice line and summing it would inflate the denominator for target attainment.

Step 2: calculate the measures in a small table

Assume the distributor has completed its September 2026 close. The table below is the complete regional summary for this example, after the invoice lines have been reconciled. All amounts are USD. Percentages are rounded to two decimal places, using unrounded inputs for totals.

Place these headers in A1:H1 and the region rows in rows 2 through 4. Calculate E2 through H2, then fill down:

E2 = B2-C2
F2 = IF(B2=0,"",E2/B2)
G2 = B2-D2
H2 = IF(D2=0,"",B2/D2)

For the total row, calculate ratios again from the totals:

B5 = SUM(B2:B4)
C5 = SUM(C2:C4)
D5 = SUM(D2:D4)
E5 = B5-C5
F5 = IF(B5=0,"",E5/B5)
G5 = B5-D5
H5 = IF(D5=0,"",B5/D5)

These are cell assignments: enter the expression following each cell address into that cell. Format F and H as percentages. A blank ratio flags an undefined denominator for review; it does not mean zero performance. The gross profit margin method explains the accounting scope behind the revenue and COGS inputs.

If the invoice export is on a worksheet called Sales, with date in column A, region in B, revenue in C, and COGS in D, regional revenue can be built with:

=SUMIFS(Sales!$C$2:$C$10000,Sales!$B$2:$B$10000,$A2,Sales!$A$2:$A$10000,">="&DATE(2026,9,1),Sales!$A$2:$A$10000,"<"&DATE(2026,10,1))

Replace the sum range with column D for COGS. Extend every range together to cover the full export. Microsoft's multiple-condition sum guidance explains the SUMIFS argument order. The exclusive end date also includes records with times on the last reporting day.

Step 3: prove the totals before making visuals

The control is an identity, not a visual inspection:

Gross profit + COGS = revenue; regional revenue variances sum to total revenue minus total target.

Here, 141,000 + 259,000 = 400,000. The regional variances are -5,000 + 5,000 + 0 = 0, matching 400,000 - 400,000. Tie revenue and COGS separately to the approved close totals; matching gross profit alone could hide offsetting errors.

The company margin is 141,000 / 400,000 = 35.25%. Averaging the displayed regional margins gives (40% + 35% + 30%) / 3 = 35.00%, which gives unequal regions equal weight. Preserve both numerator and denominator in the review evidence.

The business conclusion is specific: total revenue meets target because Central offsets East. That does not establish why East missed or whether Central's performance can repeat. Ask the regional owners for the invoice-level explanation before assigning corrective actions.

Step 4: build and pin a focused review

Use the checked measures for a headline revenue view, a regional variance bar chart, and a revenue-and-margin table. Label the period and USD basis prominently. Keep the regional table available to explain why the headline can look satisfactory while one region misses its target. The Power BI dashboard examples page covers other business layouts without changing these definitions.

With a report you can edit open in the Power BI service, hover over the chosen visual and select its pin icon. Choose a new dashboard, enter its name, and select Pin. Add further checked visuals to that existing dashboard. These steps follow Microsoft's create a dashboard from a report instructions; check permissions with your report owner if the editing options are unavailable.

Reopen the dashboard and compare every headline value to the approved table. Confirm the reporting period and included regions for each tile. Ask a reviewer to trace one region from its source lines to the table and then to its visual before the meeting.

For a workbook-led review instead, the Excel dashboard guide covers that build. The Power BI alternatives discussion addresses how to choose an approach for the work at hand.

Where it goes wrong

• Different cutoffs. Revenue through the close date and costs through an earlier date create an overstated margin. Compare the source periods before interpreting the ratio.
• Targets multiplied by transactions. Aggregate actuals before matching the regional target, and reconcile the target total independently.
• Undefined values shown as zero. An absent target makes attainment undefined. Show the missing input and assign someone to resolve it.
• Averages of regional percentages. Recalculate margin and attainment from their component totals at every reporting level.
• Filters that change the question. Record which entities, regions, and transaction statuses each visual includes. A correct number for a different population still misleads a review.

Covirage is not affiliated with Microsoft, the provider of Power BI and Excel.

Check your own business measures in Covirage

Upload your sales and target file or Google Sheet; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains movements with every figure traced to its rows, giving you source evidence to review alongside your reporting. Create a free Covirage account and bring a sample of your own export.

See self-service analytics for the supporting business workflow.