Power BI / Version 0.5.0
Variance Bridge
A Power BI waterfall and variance bridge visual for explaining movements between financial scenarios.
.pbiviz · 249 KB · Ready to import
What it is for
Walk from a comparison figure to the current figure through the lines that moved it. Explore the hierarchy without losing the opening and closing totals.
- Financial bridges and structural waterfalls with labelled opening and closing pillars.
- Hierarchy exploration, subtotal levels and grouping of smaller movements into Others.
- Scenario notation, colour options and tooltips that retain complete line names and figures.
Connect your fields
Start with the example report to see the bindings in context. For your own model, use these core fields.
| Visual field | What to bind |
|---|---|
| Line | The line names used in the chart. |
| Path | Optional hierarchy paths separated by |. When bound, Path takes precedence over the Lines hierarchy. |
| Values / Comparison | The current measure and up to three comparison measures. |
| Line order | Your ordering column, aggregated as Minimum. |
Before you build
A bridge explains the measures and hierarchy you provide; it does not infer the business cause of a movement. Review signs, comparison choice and line order against your model.
Your report data
The visual does not send your report data to Consilium. Power BI controls your report storage, access and sharing. These packages do not request web access.
Variance Bridge does not request file-export permission.
The working example
Start with the finance pack.
Download the example Power BI report, open it in Power BI Desktop and inspect how the visuals are set up. Use the field mappings and formatting as a guide for your own report.
The .pbix file is a report to open. The .pbiviz files above are visuals to import into a report. No Consilium account is needed.
1.8 MB · Power BI Desktop
Direct report downloadFile checksum
SHA-256
8c9df3287544fc6a473403906917dbb0bcd6eaa2046acf891de0b2c3a84dc3d4Getting started
Import once. Build your report.
Download a visual
Save its .pbiviz file. Keep that file format; it is the Power BI visual installer.
Import it in Power BI Desktop
Open your report. In the Visualizations pane, choose the three-dot menu, then Import a visual from a file. Select the .pbiviz file.
Add it and map your fields
Select the new visual in the gallery. Bind your measures and hierarchy using the guide on its product page, or inspect the example report first.
These are uncertified custom visuals. Your organisation may restrict their use. Check your Power BI policy before importing. Native PDF, PowerPoint and subscription output has restrictions for uncertified visuals; check your intended export workflow.
Microsoft guidance, checked 3 October 2026: importing a visual · organisational controls · certification and export support.
Updating a visual? Save, close and reopen the report after importing the replacement. Send feedback if you encounter a problem.