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:
Field Parameters
✅ Dynamic selection via slicers
❌ Does not auto-expand hierarchy
Bookmarks + Dual Matrix
✅ Pre-expanded views available
❌ Requires manual bookmark clicks after slicer changes
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
on:
Get rid of Microsoft sidebar in Power BI new works...
on:
Improve Bookmark Pane Usability: Persistent Menus,...
on:
Case Sensitivity ragrdless of the connection type ...
frithjof_v
on:
Lakehouse SQL Analytics Endpoint snapshots
on:
Power Query - Feature addition - To keep duplicat...