Development guides

Dashboard figures disagree: check definitions and update timing

Sales and finance may both report revenue but count it on different dates. A useful dashboard makes the calculation, source and last successful update visible.

ProApp editorialPublished and checked
An operations room and information display at twilight
AI-generated illustration of the article’s setting.

The workflow illustrates a possible design and is not a client case study.

Illustrative workflow
  1. Agree definitions
  2. Check and refresh data
  3. Show data status

Why can two correct reports disagree?

Suppose sales counts revenue by order date and finance by payment date. Both totals may be correct. Agree what the report is meant to help people decide, then choose the definition that fits. Check updates separately: even with the same calculation, a report that has not refreshed can show a different result.

Check Power BI refresh settings

Check the existing Power BI reports, connections and refresh settings. The missing work may be data cleaning, shared record IDs or calculation rules. Confirm how the chosen connection updates data before deciding that the display needs replacing.

Define three decision-making metrics

Start with three figures staff actually use to make decisions. For each, write down the source, calculation and how it will be checked. Show the last successful update and label old or unavailable data clearly, so missing data is not mistaken for zero. Assign someone to follow up when totals differ or an update fails.

Trace chart values to source records

Take a sample of chart values back to the original records and compare them before and after a refresh. Try refunds, cancellations, late entries and dates across time zones. If the source system is unavailable, users should still be able to tell which reporting period and data version they are looking at.

Bring the reports that disagree

Bring the reports that disagree, their definitions and data sources. Explain the decisions each report supports.

Working through a similar problem?

Tell us how you work today, which tools you use and what you want to improve. We can discuss changes to your current system, connecting tools or developing something new.