> 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/user-guide/9-scenario-planning/9-2-bidirectional-simulations-bulk-edit.md).

# 9.2 - Bidirectional simulations in Scenarios

Learn how to create bidirectional simulations that automatically distribute values down hierarchies and aggregate values to totals. Simulate multiple rows and column values simultaneously by using the bulk edit feature. Explore direct scenario value entry and distribution methods to allocate values to descendants.

## Bidirectional simulations

1. After creating a scenario, navigate to the **Scenario** ribbon, and then choose **Simulation** from the **Input Method** dropdown to begin simulating values.

![](/files/6ISpBLqVfDBvZd2POWFb)

2. To simulate the value of a cell, select the cell, and then use the simulation slider to increase or decrease the value.

![](/files/ZUzVyL8c9Ox5H85Ifxin)

3. Review the simulated values at lower hierarchy levels. Values automatically aggregate to higher hierarchy levels across both rows and columns, with variances displayed next to the values.

![](/files/OsiVEtkzDPdKaZVI55r3)

4. Simulate values at the total or subtotal level to automatically distribute values down the hierarchy.

![](/files/7nPKk7dpZWqG9AoL25Tx)

5. Review the simulated values displayed at the top of the planning sheet after the simulation is applied.

![](/files/f2bJxqXGYhIIbpNgdCZI)

6. Select **Show variance** to show or hide variances in the planning sheet.

![](/files/dYCxGEseTQJX0kqKtYHf)

7. Select **Slider settings** to configure variance settings for scenario measures.

![](/files/P6o8LJm39yEXM3vcfhpO)

8. Configure the variance value range and define whether increases in variance are treated as favorable values. In this example, the variance value range is set from -100% to +100%. Positive variances are displayed in green, and negative variances are displayed in red.

![](/files/Cd447egc0jLr2fqjGBa2)

## Bulk edit

1. Select **Bulk Edit** in the **Scenario** ribbon to simulate multiple cells simultaneously by applying filters and selecting specific row or column hierarchy levels.

![](/files/5PUmHrGgAKER4XjlHjEz)

2. Select the measure that must be simulated from the measure dropdown. In this example, the **Revenue Projection** measure is selected.

![](/files/Q27Dv0wzEh5H370IamHS)

3. Select **Add Filter** to create a new filter for the simulation.

![](/files/50Eai3F2dfGmiAmBOhcP)

4. Configure the filter values for rows or columns. Multiple filters can be applied simultaneously to narrow the selection. In this example, the filter is configured for the brand hierarchy and includes values such as Artisan Ale, Cosmic Craft Brews, and Eclipse Light.

![](/files/Z6U58cvbm4ug9sLdqAAO)

5. Use the **Apply to Row Level** dropdown to select the row hierarchy level that must be edited. In this example, the **variant** hierarchy level is selected.

![](/files/TXLNBq6w4RN2VKROIGQt)

6. Use the **Apply to Column Level** dropdown to select the column hierarchy level that must be edited. In this example, the **month\_short\_name** hierarchy level is selected.

![](/files/5iP2aFWw9cphig70iO5z)

7. Use the simulation slider or text box to configure the simulation value. In this example, the simulation value is set to 4.

![](/files/EbeNtjNovbwQnDaDAlv5)

8. Select **Apply** to apply the simulation to the filtered selection.

![](/files/jvIJviJVK383LqBHMFng)

9. Review the updated values for the filtered brand selection after the bulk edit operation is applied.

![](/files/coTSY6YlEVqFBR3uCZwc)

## Distribution method

1. Select **Distribution** from the **Input Method** dropdown in the **Scenario** ribbon to directly enter and distribute scenario values.

![](/files/d3qZQzVu01o9KmjOYMLL)

2. Double-click a cell, and then use the formula bar to enter a value. In this example, the value 15b is entered.

![](/files/gaCBERyWZzY5PxyrUEui)

3. Review the distributed values. By default, values are distributed according to the weights configured for the input column. In this example, the **Revenue Projection** column uses the **PY Revenue** measure as the default weighting series, so the scenario values are distributed by using the same weights.

![](/files/98rWQjMWjOHIjSFfgpWn)

4. To change the distribution method, select a cell, and then open the distribution menu.

![](/files/QLaOnzXihSEhSdGOAnNH)

5. Select a distribution method to allocate values across descendants by using equal distribution, trends, or weighted values from an existing series.

![](/files/af4FJDF56HcEsig4Eg0S)


---

# 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/user-guide/9-scenario-planning/9-2-bidirectional-simulations-bulk-edit.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.