Dual Hierarchy Decomposition Tree Pro

What it does.

Dual Hierarchy Decomposition Tree Pro displays your key performance indicators in an interactive, expandable tree layout that supports two independent hierarchy axes simultaneously, with DAX-driven font colors and icons at every node level.

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.

Pro features include DAX-driven per-KPI font colors and icons - each value slot can have its own color and icon driven by your DAX measures, evaluated independently at every card in the tree. Choose from 10 built-in icons (arrows, triangles, circles, checks, warnings) or override icon colors inline with hex syntax. Build conditional formatting that responds to your business logic at every drill 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.

The visual remembers your view state - expand and collapse states, zoom level, and viewport position persist across slicer changes, page navigation, and report reopens. Smart recenter keeps the active card in view when expanding new hierarchy levels.

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.

Try it free for 1 month - full Pro features unlocked during the trial period. After trial: continue with the free tier (basic tree, status bar colors, recenter, persistence) or subscribe for full Pro features.