A financial dashboard tracks results and cash health: revenue, cost, margin, and how close actuals are to the target. This tutorial builds one on top of the example model, including the budget × actual comparison from your own targets table.
Example workspace: Comércio Aurora Ltda (aurora).
Prerequisites#
- Star schema with
vendas(includingcusto) and, if available, a targets fact/table (branch/month grain) coming from your ERP or spreadsheet. - Core Receita (revenue) and Custo (cost) measures.
Measures used#
Receita = SOMA(valor)
Custo = SOMA(vendas.custo)
Margem = MEDIDA('Receita') - MEDIDA('Custo')
Margem % = DIVIDIR(MEDIDA('Margem'); MEDIDA('Receita'))Warning
If the target lives in a table with a different grain (branch/month) and you join it to
vendas (item grain), don't sum the target through the join — it would be counted several
times. Use two fact tables linked to the same dimensions (see
Relationships and cardinality); the
anti-fan-out protection blocks the incorrect sum if you try.
Dashboard layout#
| Block | Visual | Fields |
|---|---|---|
| Top | KPIs | Receita, Margem, Margem % (with Δ% vs previous period) |
| Target | KPI with target | Receita vs the month's target, with conditional formatting |
| Middle | Bars | Margem by filiais.regiao |
| Bottom | Line/area | Receita and Custo by calendario.mes |
| Bottom | Waterfall | Margin breakdown, when applicable |
Step by step#
Create the measures
Declare Receita, Custo, Margem and Margem % in the central model.
Declare the target measure
Create the
Meta(target) measure by summing your targets table (branch/month grain) and the measureAtingimento % = Receita / Meta(attainment). See Measures and formulas.KPIs at the top
Add Receita, Margem and Margem %; turn on comparison vs the previous period.
Attainment KPI
Add an
Atingimento %KPI and color the band with conditional formatting — that's what shows who is below expectations.Margin by region
Bars of Margem by
filiais.regiao; apply conditional formatting (red for negative margin).Revenue × Cost over time
A line/area of Receita and Custo by month; use a secondary axis if the scales are very different.
Publish and schedule
Publish and, if you want, schedule a weekly delivery (see Export and distribution).
Example (synthetic)#
| branch | revenue | cost | margin % |
|---|---|---|---|
| São Paulo | 250 | 190 | 24% |
| Rio de Janeiro | 90 | 95 | -6% |
Expected result#
- A negative margin shows up in red right away.
- The attainment KPI shows the gap between actual and target, with the band color.
- KPIs show the change vs the previous period.
Limits and caveats#
- The target here is your own data (a table with the target per branch/month), not a platform record: the Targets screen was removed from the product on 09/26/2026. Alerts still work per visual (see Alerts and outbound webhooks).
- Numbers reflect the snapshot from the last refresh (not real time, except with DirectQuery — see Data modes).
Related#
Last reviewed: 2026-09-08.