One Slicer to Control How Deep A Matrix Goes

Let the reader choose how deep a matrix goes — with a single slicer. Works on any dimension with a 2–3 level hierarchy.

Method: the “flat layout table” approach. Instead of hiding rows from inside your value measures, you rebuild the hierarchy as one flat table, so a simple slicer + filter can collapse it.

Contents

1. What you’re building
2. Naming used in this guide
3. The 4 building blocks
4. Block 1 — Depth (the slicer’s choices)
5. Block 2 — Layout (the flat hierarchy table)
6. Block 3 — Layout Show (the depth filter)
7. Block 4 — Layout Value (the bridge measure)
8. Wiring it up in the report
9. Optional — the “lighter look”
10. Quick test checklist
11. Why this method?

What you’re building

Instead of the + / − drill buttons, the reader uses one slicer to choose how deep the matrix goes: