> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/intelligence-sheets/how-tos/visualize-simulations-budgets-and-forecasts.md).

# Visualize simulations, budgets, and forecasts

Plan, forecast, and visualize scenarios on live data sources without duplicating datasets, rebuilding models, or relying on technical teams. By unifying planning, budgeting, and forecasting data with visualizations, you can:

* Compare budgets, actuals, and forecasts
* Quickly identify and adjust variances that require action
* Evaluate multiple what-if scenarios
* Make real-time, strategic adjustments to budgets and forecasts based on visual insights

In this article, you learn how to integrate planning data in intelligence sheets and visualize plans, budgets, and forecasts in real-time.

### Understanding scenario analysis & real-time visualization

Visualizing simulations, budgets, and forecasts allows finance teams and operational stakeholders to move beyond static, historical reporting. By embedding live planning sheets directly into intelligence sheets, you build an interactive analysis environment where drivers can be manipulated on the fly and immediately reflected across your reports and dashboards.

* Live data binding vs. static snapshots:

  Unlike traditional BI dashboards that require batch refreshes or data pipeline execution, intelligence sheets establish direct data bindings to embedded planning sheets. Any input change, scenario simulation, or formula update instantly flows through to charts and KPI cards.
* Semantic models vs. live sheet measures:
  * Base model measures: Standard actuals, historical baselines, and locked budget versions reside within the underlying semantic model. Map these measures to the Values and Comparison data wells in intelligence visuals
  * Live measures: Real-time variance drivers such as simulations, data inputs, and forecasts reside under the **From Sheets** section of the **Data** pane. Combining live measures with baseline measures allows side-by-side comparison between approved baselines and active "what-if" scenarios.

### Create a planning sheet

1. Create a planning sheet that can contain manual data inputs, simulations, scenarios, and forecasts.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FqKxgEYDoLeLKNcXsfRjW%2Fimage.png?alt=media&amp;token=268e48d5-a5bf-4fe8-9d6c-676e3fd323b1" alt=""><figcaption></figcaption></figure>

2. In a new intelligence sheet, select the **Planning** visual and choose the planning sheet to import data from.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FVS1F5zKxVsHI2IpCMBcy%2Fimage.png?alt=media&amp;token=96f3243b-1bc0-4899-9339-61206fc4a658" alt=""><figcaption></figcaption></figure>

This action embeds the selected planning sheet into the intelligence sheet.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FNUuChDfVO2cpqSPQsJ8w%2Fimage.png?alt=media&amp;token=56e94220-776d-4c83-8472-67d1de2ed6e1" alt=""><figcaption></figcaption></figure>

### Add visuals

Blend data from multiple sources by combining dimensions and measures from external files, semantic models, planning sheets, and PowerTable sheets into a single analysis.

1. Add a chart (or a visual that consumes the planning data).
2. Drag dimensions and measures from planning sheets and other data sources into the visualization to analyze them together in a single intelligence sheet.

After you embed a planning sheet, measures from the sheet, such as input values, formulas, simulations, and forecasts, appear under **From Sheets** in the **Data** pane.

In this example, the **Budget Simulation** measure is combined with dimensions and measures from a source file to create a breakdown waterfall chart and a pie chart.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FXgdZDvP7laHjmbF6kqWU%2Fimage.png?alt=media&amp;token=5c56c470-e5f1-4d43-81ea-8c7fa6d99566" alt=""><figcaption></figcaption></figure>

3. As you run simulations on the planning sheet, the charts on the intelligence sheet are updated in real time to reflect the changes. In this example, you increase the IT budget to 8.5m; the variances and bars in the breakdown waterfall automatically update in response to this change.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FALJqcpGlUOwRnGFUZigb%2Fimage.png?alt=media&amp;token=a215eb4b-8ebc-4b47-b45e-d41ea1e947a3" alt=""><figcaption></figcaption></figure>

Reduce the *Infrastructure* budget from 7M to 2M and observe how the pie chart proportions change.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FZcFdqRkfjeEA6sjx26Lt%2Fimage.png?alt=media&amp;token=b469fd6b-8c9d-478e-93e4-aa2969a7d560" alt=""><figcaption></figcaption></figure>

### FAQ

#### Why is the Planning visualization option grayed out until a Planning Sheet exists in the workspace?

The Planning visual embeds an existing Planning Sheet onto the Intelligence canvas, so at least one Planning Sheet needs to already exist in the Plan app for it to reference.

#### What happens if there's more than one Planning Sheet in the workspace when embedding?

The sheet picker ("Select an Existing Planning Sheet") lists every Planning Sheet available, and you choose the correct one. If multiple Planning Sheets exist, you should choose the correct one.

#### Once the Planning Sheet is embedded, is it a live, editable copy or a static snapshot?

It's live and editable. Adjusting any cell value in the embedded Planning Sheet updates charts, KPI cards, table, and matrix visuals in an Intelligence sheet.

#### What's the difference between mapping Comparison 1 / Comparison 2 from the semantic model versus adding "Plan (Simulation)" via "From Sheets"?

Comparison 1 and Comparison 2 pull directly from the semantic model's stored base measures (Plan, Actuals). From Sheets instead pulls a live field from the embedded Planning Sheet itself — Plan (Simulation) — which reflects whatever scenario values are currently entered on that sheet, including edits made after the KPI card was built.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/intelligence-sheets/how-tos/visualize-simulations-budgets-and-forecasts.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.