Tornado Chart by SmartVisuals

The tornado chart that actually does sensitivity analysis. Give it the output at each driver's low and high input and the base case: bars swing around the base, the widest swing goes on top, and each driver's assumptions (€620/t, 3 months, 7.5%) sit at the bar ends. The same visual draws butterfly charts, population pyramids and diverging stacked bars - the chart type follows your fields.

Free features (no licence needed):

• Sensitivity tornado with up to 5 drivers: base line, swing sort, input assumptions with per-driver units, change vs base in value or %, swing column, materiality threshold, and an insight sentence naming the widest driver
• Colour by effect (worse or better than base, lower-is-better for costs) or by input, optional hatching so direction never depends on colour alone
• Butterfly and population pyramid in full: two measures or one measure split by a field, centre spine, % of grand total, side or row, winner emphasis, independent scales
• Age bands split by Male / Female draw as a pyramid on the first drop: oldest band on top, men on the left
• Diverging stacked bars: losses left of zero, gains right, or survey answers with a neutral split at zero
• Sort by swing, value, total, difference or name; Top N with Others; drill-down hierarchies
• Four themes with their own personality and colours per category

Power BI features (all free):

• Format on the canvas (on-object formatting): click a bar, label, axis or legend and change it in place
• Conditional formatting (fx) on category colours; dynamic format strings and calculation groups
• Legend with title, position, alignment, font size and colour; click a legend entry or a pyramid side header to filter the report by that series
• Data labels with display units and decimals; axis title, gridlines, centre line and a fixed range
• Cross-filtering and highlighting, bookmarks, context menu, drilldown, tooltips and report page tooltips
• Localized in 20 languages: English, Czech, Danish, Dutch, French, German, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese (Brazil and Portugal), Slovak, Spanish, Swedish, Turkish, Chinese (Simplified and Traditional)

Accessibility (free): keyboard navigation with one tab stop (arrow keys, Enter to select, Esc to clear, Shift+F10 for the context menu), screen-reader labels with each row's values and inputs, high-contrast support, and an Accessibility card with focus outline, minimum text size and hatching.

Premium features (per-user licence via Microsoft Marketplace, $1.99 per user per month or $19 per year, first month free):

• Sensitivity analysis with more than 5 drivers (without a licence, readers see the 5 widest drivers and a note)
• Share of variance: in the insight sentence (which two drivers account for how much of the variance) and as share-of-variance and cumulative columns
• Demographic measures for population pyramids: median age, men per 100 women, dependency ratio and share aged 65+ as labelled chips, plus a median-age line on each side
• Reference overlay: last quarter's analysis, prior year or budget as an outline, tick or ghost bar
• Small multiples: one tornado or pyramid per project, plant or region
• Butterfly difference column (difference and difference %) and the net marker of diverging bars

Every premium feature is fully unlocked while you edit, so you can evaluate everything before buying. Viewers without a licence always see a working chart in the free tier - never a blocked or watermarked visual. No data leaves Power BI: the visual makes no external calls.

New in 1.1.0.0: demographic measures for pyramids, on-object formatting, legend and header filtering, dynamic format strings, axis and legend titles. The share of variance in the insight sentence and the net marker are now part of Premium; reports created before 1.1 keep them free.

Documentation and use cases: https://smartvisuals.io/visuals/tornado-chart - Support: https://smartvisuals.io/support#tornado-chart - Release notes: https://smartvisuals.io/changelog#tornado-chart - hello@smartvisuals.io