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.




