Dual Hierarchy Decomposition Tree
inden Convergent Business Technologies
Dual Hierarchy Decomposition tree with multiple KPIs & DAX-driven status colors
Dual Hierarchy Decomposition Tree
Convergent Business Technologies · Free · All features included
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.
We'd Love to Hear from You
If this visual doesn't fully meet your needs, we want to know. Our team develops these visuals based on real-world feedback — many of our most useful features have come directly from user requests. Whether you have a requirement you haven't found elsewhere in the marketplace, a workflow edge case this visual doesn't handle, or a suggestion that would improve it — please reach out, or fill this feedback form.
We also welcome enquiries from organisations with bespoke requirements — custom Power BI visuals tailored to your reporting standards, language needs, or brand guidelines.
Write to us at contactus@convergentbt.com or visit convergentbt.com. Our team typically responds within one business day.
Convergent Business Technologies · Bridging Gaps for Better Insights.
Visuelle funktioner
- Kan få adgang til eksterne tjenester eller ressourcer
