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

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