Skip to content

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

Updated on 2026-09-08

Troubleshooting: model, formula, and visual

Symptom → cause → how to check → fix → prevention catalog for the semantic model, measures/formulas, and visuals/dashboards.

On this page (5)

The BI engine's behavior is frozen by a set of reference tests (outputs pinned to an identical result on every run). If a number changes, it's because the data changed — not the formula. See Measures, formulas, and KPIs and the Formula catalog.

Formulas / measures#

SymptomLikely causeHow to checkFixPrevention
Measure returns empty/—column/table missing from the modelcheck the name in the semantic modelfix the measure's referencename columns in a stable way
Syntax error in the formulainvalid function/argumentread the formula editor's messagelook up the function in the cataloguse autocomplete and the catalog examples
Total doesn't match the sum of the rowsaggregation/filter contextcheck whether it uses an aggregatable measure (e.g., SOMA, the sum function)use the right function (see the catalog)prefer explicit measures over manual sums
Division produces an error/infinityzero/null divisortest with DIVIDIR/SEERRO (divide / if-error)use DIVIDIR(a; b) (handles zero)handle nulls at the source/Silver
Period calculation (YoY/MoM) wrongdate table/time contextcheck the model's date columnuse the catalog's time functionskeep a continuous date dimension
Number changed "on its own"source data changed (the engine is frozen)compare snapshots over timeexpected; investigate the sourcetrack freshness/lineage

Visuals / dashboards#

SymptomLikely causeHow to checkFixPrevention
Visual doesn't renderempty data after filteringremove filters to isolate itadjust the filter/queryvalidate the visual with test data
Axis/labels cut offcanvas layoutresize the widgetadjust size/themeuse the canvas editor grid
Inconsistent colors/themedashboard theme/templatecheck the applied themestandardize via the themeset a default workspace theme
Filter doesn't affect a visualvisual outside the filter's scopecheck the interactionsadjust the filter's reachdocument the cross-filter behavior
Table/matrix cuts rows on screenvirtualization (screen ≠ export)compare with the exportexport for the complete totalsee Export

Overview of problems#

  1. Isolate it: is the problem in the data (origin/pipeline), in the model (reference), in the formula (syntax/context), or in the visual (layout/filter)?
  2. Reproduce it with a minimal filter.
  3. Confirm in the semantic model that the column/measure exists with the expected name.

Security#

  • Don't paste sensitive data into tickets. Describe the formula/visual and the symptom.

Related#


Last reviewed: 2026-09-08. The BI engine is checked by a set of reference tests on every release.

Related links