> 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/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/table-templates.md).

# Table templates

IBCS table templates present business data using standardized layouts and semantic formatting. Use these templates to display actual values, variances, and key performance metrics in a consistent, easy-to-read format.

### T03: Table with measure rows

1. In the **Matrix** ribbon, select Templates and select **T03** from the **Performance** section.
2. Select the relative variance column, select **Conditional Formatting** > **Quick Rule** > **Negative** to highlight negative variances.

<figure><img src="/files/jVk22rpuFNCErxAASO3M" alt=""><figcaption></figcaption></figure>

3. To invert categories such as *costs*, in the **Data** ribbon, select the rows, then select **Invert**.

<figure><img src="/files/NlcpCF0bGrVTlMt2inkg" alt=""><figcaption></figcaption></figure>

4. To add an = sign, hover over a row, select the row gripper, and select **Add "=" symbol**.

<figure><img src="/files/CIw6fTQJuqybjOHlYkTE" alt=""><figcaption></figcaption></figure>

5. To display positive signs at the start of each row, in the **Format** tab, go to **Appearance**> **Numbers** and enable **Show Positive Sign**.&#x20;

<figure><img src="/files/XhWHMWrC3qwUTfo2gkct" alt=""><figcaption></figcaption></figure>

6. To customize cell and row borders, select the cell or row, go to the **Format** ribbon, select the border icon, and select **Custom**.

<figure><img src="/files/invGjWSC2BDaRxqZHRZt" alt=""><figcaption></figcaption></figure>

### T04: Measure rows and integrated waterfalls

Visualize variance and relative variance values in an income statement by using the T04 template.&#x20;

* Variance values are automatically plotted as a vertical waterfall chart&#x20;
* Relative variance values are rendered as lollipop charts&#x20;

1. In the **Matrix** ribbon, select Templates and select **T04** from the **Performance** section.
2. Follow the customization steps outlined in the [T03: Table with measure rows](#t03-table-with-measure-rows) section.

<figure><img src="/files/JqyY8rFD8NvAuMxrolrI" alt=""><figcaption></figcaption></figure>

### T05: Hierarchical bars and integrated bars

Visualize the actuals and variances in an income statement by using the T05 template.&#x20;

* Current and prior year actuals are plotted using solid bar charts
* Variance values are automatically plotted as colored bars
* Relative variance values are rendered as lollipop charts&#x20;

1. In the **Matrix** ribbon, select Templates and select **T05** from the **Performance** section.
2. To customize cell and row borders, select the cell or row, go to the **Format** ribbon, select the border icon, and select **Custom**.

<figure><img src="/files/GKSgAreDPM3Z6AkpsB4P" alt=""><figcaption></figcaption></figure>


---

# 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/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/table-templates.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.
