Preview

What-if scenarios

One measure over time, then its compound-growth projection at every scenario rate on one plot - the reader steps or plays through the scenarios and the emphasised projection glides to each, with the end value and the period a target is reached printed beside it; a bound What-If parameter column supplies the scenarios.

An illustration of a What-if scenarios

An illustration of the type, not a chart made from data.

What it does

What-if scenarios draws one measure over time and then its projection at every scenario rate, all on one plot. Each projection is compound growth from the last actual value. One scenario is emphasized at a time, and you step or play through them on a timeline above the chart. The emphasized line glides from one rate to the next.

Three readouts above the plot describe the emphasized scenario: its end value, its gap against a flat continuation, and when it reaches a target, when your data carries one. A row under them lists every scenario's rate and end value, so you can compare them without stepping.

The scenarios come from one source. In Power BI, a What-If parameter column you bind supplies the scenarios: its range, up to nine of its values, with both ends kept. With nothing bound, the chart builds a spread around the rate your history shows and includes that rate. A horizon slider sets how far every scenario runs. The curves are separate assumptions, so no band is drawn between them.

When it fits

Use it when the question is how far apart the outcomes of several assumptions land: revenue under a range of growth rates, headcount, subscribers. It needs one measure over dates with at least six periods.

When it doesn't

It isn't a forecast and it draws no likely range. If you want to steer one rate yourself and watch the answer move, What-if projection is the simpler chart. Stepping through scenarios filters nothing on the page, because a scenario isn't data.

The data it needs

A dated measure with at least six periods when the question is how far apart the outcomes of several assumptions land - revenue under a range of growth rates, headcount, subscribers; bind a What-If parameter column to draw exactly the range you defined.

Smallest size it draws at: 294 by 320 pixels.

How to ask for it

Pick What-if scenarios from the list of what fits your data, or describe it in your own words:

  • “Show what-if scenarios for revenue at several growth rates so I can compare where each one ends”
  • “Play through growth scenarios for headcount over the next twelve months”

Where it runs

Power BI
Add the RegiaBI Apps, Maps and Charts visual from AppSource to your report, bind a date and a measure, and pick What-if scenarios from the list of what fits your data, or ask for it by name.
Excel
Get the RegiaBI Apps, Maps and Charts add-in from Home > Add-ins, select your table, and pick What-if scenarios from the list of what fits.
AI agents
Add the MCP server to your coding agent with npx -y @bicharts/chart-mcp. The agent asks which types fit your table, generates this one, and gets it as source code for your app.

Try it

Try it with Divisional Revenue by Year

Start with your own data: the Power BI visual, the Excel add-in, the MCP server for AI agents. It lists the types that fit your data before it builds anything.

Questions people ask

Where do the scenario rates come from?

From a What-If parameter column you bind, when there is one: the chart draws its range, up to nine values with both ends kept. A bound parameter measure sets the emphasized rate, with a spread around it. Otherwise it builds a spread around the rate your history shows, and that historical rate is one of the scenarios.

Is the space between the lines a confidence range?

No. Each line is a separate assumption at a stated rate. The chart fits nothing to the history and draws no band between the lines.

Does stepping through scenarios filter my other visuals?

No. A scenario is an assumption, not rows of data, so stepping or playing changes only this chart.

Why does it say Preview?

It's available now and still being refined. A preview is built only when you pick it from the list or ask for it by name.

This application may no longer respond until reloaded. Reload 🗙