Dual Hierarchy Decomposition Tree

An interactive, expandable KPI tree with two independent hierarchy axes. Add fields to Hierarchy 1 (Horizontal) to drill rightward — by Region or Department — and to Hierarchy 2 (Vertical) to drill downward — by Category or Product — for matrix-style analysis. Each card displays up to four KPI measures with a DAX-driven status bar that accepts hex codes for traffic-light or threshold-based coloring, evaluated independently at every node.

Key Capabilities

Up to 4 KPIs per Card — Four measures per card with correct aggregation for numeric, ratio, percentage, and string types.

Bi-Directional Tree Layout — Expand hierarchies horizontally and vertically within a single visual.

DAX-Driven Status Bar — Color the status bar from a DAX measure returning hex codes, evaluated at every node.

Per-KPI Value Formatting — Independent font, size, color, display units, and decimal places per slot, or a global style.

Hierarchy Labels — Contextual label on each card identifying its position in the hierarchy.

Multi-Level Drill-Down — Expand and collapse multiple levels on both axes using per-card controls.

Zoom & Pan — Ctrl+scroll zoom, click-drag panning, fit-to-page, and a zoom toolbar.

Cross Filtration — Full Power BI cross-filtering with single-click card selection.

Tooltips — Hover tooltips with canvas tooltip support at every node.

Full Format Pane Control — Customize card size, gaps, fonts, colors, and alignment.

Coming Soon

Upcoming releases will add selection state options, animated card expansion, dynamic font colors, and per-KPI indicators.