Templates
KPI dashboard template
A one-screen KPI layout with the definitions and formulas written out.
Updated September 20, 2026
Data sheet columns
| Column | Type | Notes |
|---|---|---|
| Period | Date | Month end, ISO format |
| Metric | Text | From a controlled list |
| Actual | Number | Current period value |
| Target | Number | Plan for the period |
| Prior | Number | Same metric, previous period |
Calculations
Variance = Actual - Target
Variance % = IFERROR(Actual/Target - 1, "")
Change vs prior = IFERROR(Actual/Prior - 1, "")
Status = IF(Actual >= Target, "On track", "Behind")Layout
- Row of cards: one per metric, showing Actual, Variance % and direction
- Trend chart: Actual by Period for the primary metric
- Table: all metrics with Actual, Target, Variance %, Status
Frequently asked questions
How many metrics should this template hold?
Six to nine. More than that and the cards stop being scannable.
Related reading
Analyze your data with AI
Open the GridMind workspace, bring in a CSV, Excel file or your Power BI model, and let AI build the formulas, charts and dashboards for you.