Measure Killer Measure Killer

How do I see where the numbers in a KPI, measure or visual come from?

Right-click the measure, visual or page and pick View column lineage graph. Measure Killer draws the chain back through every measure it builds on, the model columns and Power Query steps, to the source columns in the database, file or dataflow the numbers start in.

Last updated · November 6, 2026

Steps

  1. Run any scan that contains the measure or report: a local file in Single model and report (free), Shared model online, or Tenant Analysis / Limited Tenant Analysis with the model analyzed (which mode?).
  2. Find the measure, the visual or the page in the result. The search bar finds it by name.
  3. Right-click it and pick View column lineage graph.
  4. Read the graph from right to left: the KPI or visual on the right, then every measure it builds on, the model columns, the Power Query steps, and on the left the source columns where the numbers start (details).
  5. Click a column to highlight its path and fade the rest. Focus selected zooms to it, and Export HTML saves the graph to share.
  6. Prefer a list? View column lineage in the same menu shows the same chain as a tree.

What you see

Lineage graph of a measure traced back through its model columns and a Gen1 dataflow to two columns of an Excel table on SharePoint, and forward into a second semantic model

Go deeper

Something wrong or out of date on this page?

Report an issue with this page

Tell us what is wrong or out of date. No email needed.