https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image2_Logo300x300.png
AdvanVis - Smart Waterfall and Bridge
Waterfalls that add up: subtotals found, budget bridges, an axis break and plain-English insights.
AdvanVis - Smart Waterfall and Bridge draws waterfalls that add up and explains them in plain English: a profit and loss walk with its subtotals found for you, a bridge from budget or last year to actual from two measures, and a headline that says what moved the total.
FREE FEATURES (no licence needed, no watermark)
• Steps from a Category, or from several measures with no Category and no unpivoting
• Subtotals found in your data (Gross profit, EBITDA), added after any step, or named
• Costs stored as positive numbers are subtracted so the subtotals add up
• Period chain with a Breakdown: each period a total, with what changed between them
• Opening and closing totals, automatic with an override
• Sort by size or direction, Top N with Other
• Columns or bars, picked to fit the names and figures
• A clearly marked axis break, so small steps stay readable beside large totals
• Data labels with a second line (% of the first total, % of the total before, or change %), connector lines, a legend and a reference line (Analytics pane)
• Step colours by rule (fx), and "Increase is good" for costs
• Cross-highlighting, cross-filtering, drill-down, tooltips, Show condition
• Basic headline, keyboard navigation, screen reader text and high contrast support
PRO FEATURES (additional purchase may be required; one-month free trial through Microsoft AppSource)
• Bridge from Compare to or Target: the starting total, every item's difference, the actual total
• Two bridges in a row: last year, to budget, to actual, in one chart
• Total change marker: the difference between the first and last total, as an amount and a %
• Smart insights: a headline and findings on the biggest increases and decreases, movements that cancel out, the few steps behind most of the change, subtotals as a share of the first total, new and lost items, and what Other holds
• Checks: a total in your data that does not match its steps is reported with the difference
• How calculated: hover or Tab to any finding to see the numbers behind it
• Design tips while editing
In Power BI Desktop every feature can be used while you build your report. When the report is shared in the Power BI service, viewers need the Pro plan to see the Pro features; everyone else sees the free chart.
HOW THE INSIGHTS WORK
The findings are worked out inside the visual by built-in rules (sums, shares and comparisons of the steps) and written in plain English from templates. No generative AI is used.
PRIVACY
Everything is calculated inside the visual from the data in your report. No data leaves the report and the visual makes no network calls.
GET STARTED
Add the visual, then drag a field into Category and a measure into Values, or drop several measures into Values on their own. Add Compare to or Target or budget for a bridge. Download the sample report for a guided tour of every feature.
Support: https://advanvis.co.uk/support
Visual capabilities
This visual is certified by Power BI
At a glance
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image0_01bridgefrombudgettoactual.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image0_01bridgefrombudgettoactual.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image3_02profitandlosswalk.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image1_03twobridgesandother.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image4_04periodchainandcashwalk.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image5_05axisbreaklabelsandchecks.png