Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

Updated on 2026-10-04

Tutorial: financial dashboard

A dashboard for revenue, cost, margin and flow with a budget × actual comparison.

On this page (8)

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 (including custo) 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#

code
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#

BlockVisualFields
TopKPIsReceita, Margem, Margem % (with Δ% vs previous period)
TargetKPI with targetReceita vs the month's target, with conditional formatting
MiddleBarsMargem by filiais.regiao
BottomLine/areaReceita and Custo by calendario.mes
BottomWaterfallMargin breakdown, when applicable

Step by step#

  1. Create the measures

    Declare Receita, Custo, Margem and Margem % in the central model.

  2. Declare the target measure

    Create the Meta (target) measure by summing your targets table (branch/month grain) and the measure Atingimento % = Receita / Meta (attainment). See Measures and formulas.

  3. KPIs at the top

    Add Receita, Margem and Margem %; turn on comparison vs the previous period.

  4. Attainment KPI

    Add an Atingimento % KPI and color the band with conditional formatting — that's what shows who is below expectations.

  5. Margin by region

    Bars of Margem by filiais.regiao; apply conditional formatting (red for negative margin).

  6. Revenue × Cost over time

    A line/area of Receita and Custo by month; use a secondary axis if the scales are very different.

  7. Publish and schedule

    Publish and, if you want, schedule a weekly delivery (see Export and distribution).

Example (synthetic)#

branchrevenuecostmargin %
São Paulo25019024%
Rio de Janeiro9095-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.

Related links