# Compare Scenarios

Plan compare scenario is one of the most powerful ways to unlock deeper insights from your data. Whether you're analyzing budget vs. actuals, forecast revisions, or multiple what-if models, Plan's scenario comparison features help you visualize variances, track performance shifts, and make data-driven decisions with confidence. With dynamic columns, variance analysis, and real-time recalculations in Microsoft Power BI, users can seamlessly compare financial, operational, and strategic scenarios in a single, interactive report.

### Key Features of Compare Scenario

1. Dynamic Scenario Creation & Management
2. Snapshots for Baseline Comparison
3. Visual Side-by-Side Comparison
4. Real-Time What-If Simulations
5. Top-Down & Bottom-Up Analysis
6. Automatic Variance Metrics
7. Permission & Collaboration Controls
8. Writeback & Export Capabilities
9. Time-Frame Scenario Filtering
10. No-Code, Interactive UI

### Compare scenarios

Create various scenarios that you would like to compare. Click here to know more about creating [scenarios](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario.md). You can click on **Scenario > Compare Scenarios.**

In the scenario comparison model, under the **Compare dropdown,** select the scenario to be compared. Under the **With** dropdown, select the scenarios to be compared. You can compare multiple scenarios simultaneously for deeper and more comprehensive analysis.

{% hint style="info" %}
Non-numeric measures and columns cannot be compared.
{% endhint %}

You can compare either all measures or select specific ones from the **Measures** dropdown. Additionally, you can define the levels for comparison within the scenarios. In the example below, the levels represent time hierarchies such as Year, Quarter, and Month.

You can choose to compare all the measures or choose to compare specific measures from the M**easures** dropdown. You can also choose the **Levels** to be compared within the scenarios. In the example below, levels are time periods like Year, Quarter, and Month.

{% hint style="info" %}
Common timelines and numeric measures can be compared.
{% endhint %}

The variance between the compared scenario measures is viewed.

#### View Simulations

You can run simulations directly within the Compare Scenarios feature to quickly achieve your desired outcomes, significantly reducing the time required for what-if analysis. The simulated values can be viewed under the **View Simulations.**

#### **Export Report**

The compared scenarios and the simulations performed can be exported as PDF or EXCEL reports by clicking the **Export Report** option. Click here to know more about [Export](/planning-sheets/how-tos/10.-exporting-reports/export.md).

#### Copy to Clipboard

The simulated native measures can be copied to the clipboard and exported as a CSV file, which can be reused later.


---

# Agent Instructions: 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:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario/compare-scenarios.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.
