Flexa Intel logo
Flexa Tables

Features that turn a table into a workspace

Flexa Tables brings the flexibility of a spreadsheet to a published Power BI report. Readers pivot, compare, calculate and format the data themselves — no Power BI Desktop, no DAX, no new report request.

Updated Aug 5, 202616 features across 4 areas New here? Start with Get Started →
Group 1

Build the table

Everything a report consumer needs to shape data without leaving the report page.

Pivot with drag & drop

Reshape the table from the report itself — no Power BI Desktop, no DAX.

Footer › PivotCore

The Pivot panel holds the Field List and four drop zones. Drag a field into a zone and the table rebuilds instantly. Give viewers the Column Configurator and one report can answer many different questions.

What you can do

  • Rows — fields that build the rows; several fields create a hierarchy.
  • Columns — fields that build the columns; several fields create multi-tier headers.
  • Values — the numbers to aggregate; place as many as you need side by side.
  • Filters — narrow the whole table from a chip above the grid.
  • Search the Field List, reorder fields inside a zone, or remove them with one click.
Pivot — Column Configurator Demo
Pivot panel
The Field List and the four drop zones — Filters, Rows, Columns and Values.

Hierarchies, subtotals & grand total

Drill from the big picture down to detail inside a single table.

Automatic

Put more than one field into Rows or Columns and Flexa Tables builds a hierarchy: every branch expands and collapses on its own, each group carries its subtotal, and the grand total closes the table.

What you can do

  • Expand or collapse any branch with the arrow on the row.
  • Subtotals per level, recalculated against the active filters.
  • Multi-tier column headers when Columns holds more than one field.
  • Grand total can be relabelled or switched off in the format pane.
Row hierarchy
Region › City expanded — subtotal per region, grand total at the bottom.
Multi-tier columns
Two fields in Columns produce a two-tier header.

Matrix and Tables modes

One visual covers both the summarised view and the record-level view.

Top-left toggle

Matrix is the pivot view with hierarchies and totals. Tables is a flat, detail view where each selected field becomes a column — tuned to stay smooth across tens of thousands of rows.

What you can do

  • Switch modes from the toggle in the top-left corner; each mode keeps its own setup.
  • In Tables mode, tick several fields and press “Move to values” to add them at once.
  • Reorder columns by dragging the chips in the Values zone.
  • The real row count is always shown in the bottom-left corner.
Tables mode
Tables mode — one column per field, total row at the bottom.

Sorting & inline filtering

Narrow and order the data straight from the column headers.

Column header

Every header carries a sort control and a funnel. Filters apply as you type, several columns can be filtered at once, and both survive a page switch.

What you can do

  • Click a header to sort ascending, click again for descending — the total row stays pinned at the bottom.
  • Text columns: Is, Is not, Contains, Starts with, Does not contain, Does not start with. Separate several values with a comma.
  • Value columns: Equals, Not equal, Less than, Less than and equal, Greater than, Greater than and equal. Separate several values with a semicolon.
  • The funnel of an active column changes colour so readers know the table is filtered.
Sorting
Sorted by a value column — the total row never moves.
Text operators
Operators offered for a text column.
Number operators
The same funnel on a value column offers numeric operators.
Group 2

Analyse

The Analytics panel adds comparison, custom maths and alternative totals — all without touching the data model.

Variance by category

Compare one group against one or many others.

Analytics › Variance

Drag a categorical field — brand, region, product — into “Compared By”. The table gains a Base column, a Measured column and a ΔVar column. Pick several measured groups and each one gets its own difference column.

How to set it up

  1. 1Merge the tables you want to compare into a single table, then build a standard pivot with Rows, Columns and Values.
  2. 2Open Analytics › Variance and drag the comparison field from the Field List onto “Compared By”.
  3. 3Close the panel and use Base Field / Measured Fields above the grid to change what is compared.

What you can do

  • Optional calculations: ΔVar (on by default), ΔVar % and Ratio.
  • Difference columns sort, filter, format and export like any other column.
Category variance Demo
Base vs Measured
Base, Measured, ΔVar and ΔVar % — negative differences stand out in red.

Variance by date

Put two periods side by side and read the movement.

Analytics › Variance

Drop a date field into “Compared By” and the table switches to a period comparison: Prev, Cur and ΔVar. Change the two periods from the toolbar above the grid at any time.

How to set it up

  1. 1Build a standard table with Rows, Columns and Values.
  2. 2Drag a date field into the Column Configurator — use the real date field, not the Date Hierarchy.
  3. 3Open Analytics › Variance and drag that date field onto “Compared By”.
Date variance Demo

Simulations — calculated columns & rows

Write your own formula on top of the table: what-if, plan versus actual, derived KPIs.

Analytics › Simulations

Build an expression by dragging field chips into the editor and typing the operators around them — so a field name can never be misspelt. Three scopes decide what the formula produces.

What you can do

  • Values — a new value column next to the existing ones, e.g. Var = Actual PnL − Plan PnL.
  • Columns — a single column that merges columns already on the grid, e.g. Adidas + Apple.
  • Rows — a new row inserted before the total row and counted into the grand total, e.g. Cap + Shirt.
  • Arithmetic +, −, ×, ÷ and parentheses; aggregate helpers SUM(field) and AVERAGE(field).
  • Advanced mode adds a condition: IF <field> <operator> <value> THEN … ELSE …
  • Chain formulas — a formula can consume the result of an earlier one. Edit with the pencil icon in the Field List.
Basic simulation Demo
A plan-versus-actual column built with a simple expression.
Advanced simulation Demo
Aggregate functions and IF / THEN / ELSE conditions.

Show Values As

Turn any value column into a share of the total.

Analytics › Show Values As

Each value column has its own selector, so one table can show an amount in one column and a contribution percentage in the next. Only the options that make sense for the current layout are offered.

What you can do

  • % of Grand Total — needs both rows and columns.
  • % of Row Total — needs columns.
  • % of Column Total — needs rows.
  • % of Parent Row — needs a row hierarchy of at least two fields.
  • Switch back to Absolute at any time; decimal places follow the Custom Value settings.
Percent of grand total
Every cell as a share of the grand total.

Summary Type

Decide how the total row is calculated, column by column.

Analytics › Summary Type

The total row defaults to a sum. Change it per column to Average, Min or Max — so revenue can keep adding up while unit price shows an average on the same row.

Good to know — Only the grand total changes. Group subtotals keep summing, so the structure of the table stays consistent.

Summary Type
One selector per value column.
Group 3

Visualise

Bring the reader’s eye to the number that matters and keep the table on brand.

Conditional formatting

Four styles — thresholds, colour scale, icons and automatic anomaly detection.

Footer › ConditionalNeeds a value

Click Conditional to open the panel. The first selector picks the style, the second picks the column the rule is measured against. Use the “+” button to add a tab and format each value column separately.

What you can do

  • Rules — a lower and an upper bound per rule with your own colour. Leave one end blank for “no limit”, and stack several rules to paint high and low bands differently.
  • Gradient — a colour scale by magnitude; anchor the ends automatically or to fixed numbers so reports stay comparable between periods.
  • Icon Set — 3 Arrows, 3 Traffic Lights, 3 Flags, 3 Symbols or 3 Diamonds across three tiers; hide the number to leave only the signal.
  • Anomaly — flags outliers for you, using either Z-Score (multiples of the standard deviation, default 2) or IQR (multiples of the interquartile range, default 1.5).

Good to know — The total row is never painted, and on a hierarchy only leaf rows are coloured — subtotals stay clean.

Conditional formatting Demo
Icon Set
3 Arrows — green, amber and red by tier.
Anomaly detection
Anomaly detection marks the outliers without you setting a threshold.

Sparkline & in-cell chart

Trend and magnitude next to the numbers, not on a second visual.

Footer › Sparkline / Chart

Turn Sparkline on and every row — and every value column header — gets an icon that opens a trend chart. Hovering a point shows exactly the figure printed in the grid, and on a hierarchy you can step from group level down to detail.

When variance is active the button becomes Chart: bars are drawn straight inside the difference column, positive and negative on opposite sides, with the value still readable.

What you can do

  • Six sparkline styles, line by default; switch style inside the chart window.
  • Column sparklines skip the total row so the scale stays meaningful.
  • In-cell variance chart offers Bar, Pin and Size Dot, for all columns or the difference column only.
In-cell chart Demo
Sparkline
The row trend — values match the grid exactly.

Custom Color

Match the table to your reporting standards.

Format visual

Personalise the colours of the grid: header background and text, a distinct treatment for the total row, horizontal and vertical grid lines, and alternating row shading that makes long tables easier to scan.

Custom Color Demo

Custom Value

Number formatting that fits the audience.

Format visual

Set the display unit (None, Thousand, Million, Billion, Trillion), decimal places from 0 to 4, the thousands separator, a currency format by locale, and how positive and negative numbers are written.

Custom Value Demo
Group 4

Operate

Day-to-day conveniences that keep a report tidy and get the numbers out again.

Manage columns & rows

Show, hide and reorder without touching the data setup.

Footer › Manage

The Manage panel has two tabs. Columns lists every column on the grid with an eye icon to hide or show it and a handle to drag it into place — hidden columns keep their data, so the row count never changes. Rows lets you reorder groups and expand a parent to arrange its children.

What you can do

  • The row-label column is locked so the table never loses its reading axis.
  • Parent groups expand to reveal their members; hiding a parent hides the whole group.
  • Reordering a child label applies to that label under every parent, keeping groups consistent.
  • Formula columns and rows appear here too — and hidden columns are left out of the Excel export.
Manage Demo

Layouts

Up to five saved report setups inside a single visual.

Top-left › Layouts

A Layout is a complete snapshot: pivot structure, formulas, conditional formatting, variance, percentage display, total type, hidden columns, filters, sort order, sparkline settings and even the Matrix / Tables mode.

What you can do

  • Create a layout from the current state, duplicate it to experiment, rename or delete it.
  • Up to five layouts per visual, with at least one always kept.
  • Every change is saved automatically — there is no Save button to forget.
  • Switching applies the snapshot almost instantly, even across display modes.

Good to know — Instead of stacking four or five tables on one page, ship a single table with a layout switcher — the page stays light and the reader stays oriented.

Layouts menu
Saved layouts with rename, duplicate and delete actions.

Export to Excel

What you see is what you paste.

Footer › Export data

Copy to excel puts the table on the clipboard for a direct paste into Excel or Google Sheets, multi-tier headers included. Download .xlsx produces a file that also carries the conditional formatting colours.

What you can do

  • Hidden columns stay out; active filters, sort order and formula columns are respected.
  • Percentage display, total type and number formatting come across exactly as shown.
  • Collapsed groups still export their detail rows, and large tables export in full — not just the part scrolled into view.
  • Select rows first to copy only that selection; oversized copies are reported rather than silently truncated.
Export data
Two ways out: clipboard copy, or a formatted .xlsx file.

Need more help?

Have a question about a feature or a report you are building? Our team answers documentation and product questions directly.

Connect with the Support Center Installation guide
< Back to Getting Started <> Next to Flexa Design >