Dynamic “Crosstab” Matrix in Power BI: N-Level Dimensions + Dynamic Measures

[Buddyy1512]

I’m building a self-service “crosstab” matrix in Power BI that behaves like a Tableau-style pivot table:

• Users can select N row dimensions via slicers

• Users can select N measures via slicers

• The matrix should auto-expand every level of the hierarchy—no drill icons, bookmarks, or manual clicks—and update instantly when slicers change

---

What I’ve Tried So Far:

1. Field Parameters
   ✅ Dynamic selection via slicers
   ❌ Does not auto-expand hierarchy

2. Bookmarks + Dual Matrix
   ✅ Pre-expanded views available
   ❌ Requires manual bookmark clicks after slicer changes

3. Flattened Approach (Calculated columns + unpivoted metrics)
   ✅ Always-expanded, single matrix
   ❌ Complex DAX and high maintenance overhead

---

Where I’m Stuck:
Each solution checks some boxes but never all at once. I need a single matrix that:

• Dynamically picks any number of row fields via slicer

• Dynamically picks any number of measures via slicer

• Always renders fully expanded, with zero extra interaction

---

What I’m Looking For:
Are there any new Fabric features, Calculation Groups, or upcoming matrix enhancements that can handle this pattern? Any pointers or prototypes would be hugely appreciated!

Link for reference:Solved: Re: Dynamic “crosstab” in Power BI: multi-level di... - Microsoft Fabric Community

[andyclap]

Agree - it would be nice for the matrix to have an option on rows/columns to always expand to deepest level. The drilldown UX is very unintuitive for such a powerful visual with field parameters. I've standardized on using [+/-] icons on the rows as business users get that, but there's no equivalent for columns. I'm coaching users to experiment with the explore data options now - they often just export to excel anway!