Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-waterfall-bridge-191ec8e1-906e-4006-a781-51a221854b89/image2_Logo300x300.png

AdvanVis - Smart Waterfall and Bridge

by AdvanVis

Free Trial
Download SampleInstructions

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
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.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
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies