You are asked why two visuals showing the same metric give different numbers. How do you explain it?

< 1 min read

First, I would review both visuals to confirm they are using the same metric but check if there are differences in filters, date ranges, or dimensions.
Often the numbers differ because one visual may have additional filters or a different level of aggregation.
Next, I would check the calculation logic and data source used by each visual to ensure they are consistent.
For example, in one dashboard the revenue KPI card showed total revenue, while the chart showed revenue by region with a filter applied.
I would explain to the stakeholder how those filters or grouping levels affect the numbers displayed.
If the difference is expected, I would clearly walk them through the logic so they understand the context.
If the difference is caused by a configuration issue, I would correct the visual or calculation.
Finally, I would ensure labels, filters, and metric definitions are clearly shown to avoid future confusion.

Power BI Essentials