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.

The workflow illustrates a possible design and is not a client case study.
- Agree definitions
- Check and refresh data
- 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.