Skip to main content

Table Tiles

Learn how table tiles turn sheet data into structured, presentation-ready tables, and how to style rows, columns, and visualizations for clear, IBCS-aligned reporting.

Updated this week

An example of an IBCS compliant table

What are table tiles?

Table tiles turn sheet data into structured, presentation-ready tables. They preserve the logic and hierarchy of the underlying sheet while giving you fine-grained control over layout, formatting, and visual emphasis.

A table tile doesn’t change the data itself. It reflects what’s defined in the sheet and lets you focus on how that data is displayed. They inherit their structure directly from the sheet:

  • Rows stay hierarchical and expandable.

  • Columns follow the sheet’s column order exactly.

  • Values behave the same as in the sheet.

From there, table tiles let you style rows and columns independently, apply visual encodings, and align the output with reporting standards like IBCS.

Table columns

Columns are edited directly in the table tile. Hover over a column header and click it to open the column options popover.

This keeps you in context and makes it easy to adjust multiple columns quickly.

Column styling and formatting

Column options

Each column has its own styling controls:

  • Text size, color, and emphasis

  • Custom number formatting

  • Width and spacing (gap to the next column)

Column formatting can override or extend row formatting. For example, a row can remain bold while a column applies conditional coloring based on values or trends.

Custom formatting and preserve formatting

Custom formatting applies column-specific number and text formatting directly in the table tile.

Preserve formatting keeps the column’s original formatting intact, ignoring any custom formatting applied at the tile or row level. This is especially useful for calculation columns, such as percentage differences, where the original format should always be retained.

Column visualizations

Columns support built-in visualizations that encode meaning directly into the table. Each visualization follows a clear semantic rule and can be customized where applicable.

Available options include:

  • None: Shows values only

  • Conditional formatting: Colors negative and positive values differently

  • Bar chart: Visualizes absolute values or variances

  • Pin chart: Highlights relative variances

  • Waterfall: Shows positive and negative change by trend, with optional totals

  • Up / down arrows: Indicates direction by value

  • Traffic lights: Uses semantic states with fixed behavior

For color-based visualizations, you can use a fixed color, color values dynamically, or color by trend. Positive and negative colors can be adjusted independently.

Shared scale

Example of a shared scale between two bar columns

Visualizations can optionally use a shared scale. When enabled, columns assigned to the same scale group are scaled relative to each other.

Farseer provides four scaling groups. Any columns using the same group will share a common scale, making visual comparisons across columns more accurate and consistent.

This is especially useful when comparing variances, deltas, or trends across multiple columns.

Semantic headers and footers

Example of semantic headers being used

Columns support semantic styling at both the top and bottom to visually distinguish scenarios or meanings.

Available styles include:

  • Thin: Default style

  • Thick: Typically used for actuals (dark) and previous years (grey)

  • Double: Typically used for plan versions

  • Hatched: Typically used for forecast versions

The same semantic style is applied consistently to the column header and footer, making comparisons easier to read.

Column rows

Each row has its own styling controls, similar to columns:

  • Text size, color, and emphasis

  • Custom number formatting

  • Backgrounds

  • Borders

Rows are expandable and collapsible, just like in the sheet. You can also expand or collapse an entire hierarchy level at once using the controls that appear when you hover over the table tile.

What to keep in mind

  • Table tiles always respect the column order defined in the sheet.

  • Formatting is layered: global → row → column.

  • Visualizations and styles affect presentation only, not calculations.

Table tiles are designed to help you move from model to report with minimal friction—keeping structure, adding clarity, and making financial narratives easier to read.

Did this answer your question?