Page pattern

Operational Table

Give operational users the full working table with sorting, hierarchy, formatting, totals and export.

DetailBasicArchetype: List / Results
Typical user questions
  • What are today's numbers per item?
  • Which rows do I need to work on?
  • Can I export this list?

Operational Table — clickable example

Shared retail dataset. Every control works; the log shows what Power BI would change.

Simulation of native Power BI behaviour
Filter contextDepartment:All
Global filtersfilters
DepartmentAll
Optional KPI summarykpi
Revenue€8.4Mvs Budget€8.5M -1%Attention
vs Previous year€8.4Mvs Previous year€8.3M +1.4%On track
Margin€2.1Mvs Benchmark€2.1M -0.2%Attention
Large table / matrixdetail
Hierarchy: department › productGroup › productExpanded level 1 of 3
RowsRevenueBudgetvs Budget
€2.4M€2.5M-0.9%
€1.7M€1.7M-0.7%
€1.7M€1.7M-0.8%
€1.4M€1.4M-1.4%
€1.2M€1.2M-1.7%
Total€8.4M€8.5M-1.0%
Drillthrough / exportnavigation
What Power BI would do
  • Interact with a slicer, a bar or a navigation button to see the native behaviour described here.

List / Results — archetype wireframe

[ Filters ] [ Summary / count ] [ Sortable results ] [ Selection state ] [ Detail action ]

Simulation of native Power BI behaviour
Zone 1
Filters
Zone 2
Summary / count
Zone 3
Sortable results
Zone 4
Selection state
Zone 5
Detail action

Reading order follows the zones above, top-left to bottom-right.

Designer

Components: Table, Matrix, Slicers, Conditional formatting

Hierarchy: Context/control → status/primary answer → explanation/breakdown → detail → next step.

Developer

Interaction: Use only interactions that support the page's next analytical step; typical next level: **Entity detail**.

Navigation: Entity detail

Implementation: Compose from the listed native visuals/controls and the standard interaction patterns in this guide; custom visuals are exceptions.

Common mistakes
Treating the archetype as a rigid screen; adding unrelated analytical tasks; duplicating controls already handled globally.
Related entries