Skip to main content
Convergent Business TechnologiesBook a Call
Power BI · Microsoft AppSource

Hierarchical KPI Cards Tree

Up to four KPIs per card across two hierarchy axes, with DAX-driven status colours.

Preview of Hierarchical KPI Cards Tree

What it does.

Hierarchical KPI Cards displays your key performance indicators in an interactive, expandable tree layout that supports two independent hierarchy axes simultaneously.

Add fields to Hierarchy 1 (Horizontal) to expand cards to the right — for example, by Region or Department. Add fields to Hierarchy 2 (Vertical) to expand cards downward — for example, by Category and Product. Use one axis or both together for matrix-style analysis across two dimensions.

Each card displays up to 4 KPI measures side by side: revenue, target percentage, year-over-year growth, status text, or any DAX measure you choose. Numeric values aggregate correctly on parent nodes using Power BI’s native subtotal engine, and percentage or ratio measures use DAX-evaluated totals rather than simple averages. String measures such as status text also display correctly at every aggregation level.

The colored status bar at the top of each card can be driven by a DAX measure returning hex color codes, enabling traffic-light indicators, threshold-based coloring, or any custom business logic — evaluated independently at every node in the tree.

Format each KPI slot independently with its own font, size, color, display units, and decimal places, or apply a single global style to all values. Customize card dimensions, gaps, title formatting, label formatting, background colors, and border colors from the standard Power BI format pane.

Navigate large trees with Ctrl+scroll zoom, click-drag panning, fit-to-page, and a built-in zoom toolbar.

What ships today, what’s next.

Available now10 capabilities

  • Up to 4 KPI measures displayed per card
  • Bi-directional tree layout with horizontal and vertical hierarchy axes
  • DAX-driven status bar color with hex code support
  • Per-slot value formatting: independent font, size, color, display units, and decimal places for each KPI
  • Correct aggregation on parent nodes including ratios, percentages, and string measures
  • Multi-level drill-down on both axes with expand/collapse controls
  • Ctrl+scroll zoom, click-drag pan, fit-to-page, and zoom toolbar
  • Cross-filtering with single-click card selection
  • Native Power BI tooltips with canvas tooltip support
  • Customizable card size, gaps, fonts, colors, and alignment from the format pane

On the roadmap3 planned

  • Conditional Formatting
  • Color Coded Indicators for Values with Threshold
  • Reference Values

Need a custom Power BI visual built for your reporting?

Thirty minutes with a senior BI consultant. We’ll walk your report, scope the visual, and tell you whether a build makes sense.

Talk to our BI team →