Expand/Collapse Matrix

Hierarchy Toggle Buttons

Build

Featured Image

Overview

Features

Prompts

Troubleshooting

Key Features

Add Expand All / Collapse All buttons to any matrix with hierarchy rows using bookmark-based visibility toggle.

Your matrix has two or three row levels — a user opens the report and sees everything collapsed. They click the expand arrow on each row, one by one, to see the detail. There's no "Expand All" button in Power BI. Building one yourself means duplicating the matrix with pinned expansion states, creating two action buttons with bookmark-based visibility toggle, writing bookmark files that correctly show/hide four visuals at once, and getting the VCO formatting right so the buttons don't look broken. This skill builds the entire toggle — expanded matrix, buttons, bookmarks, and visibility wiring — in one command.

How it works

Type /expand-collapse-matrix, select your matrix, and the skill builds the full toggle:

  1. Duplicates the matrix as an exact copy (same fields, formatting, filters)

  2. Sets all row projections to active: true and adds expansionStates with isPinned: true to force full expansion

  3. Creates two action buttons — "Expand All" and "Collapse All" — positioned inside the same visual group

  4. Creates two bookmarks that toggle visibility between the collapsed and expanded matrices

  5. Hides the expanded matrix and Collapse All button by default

  6. Registers the bookmark group in bookmarks.json

What you get

  • Expanded matrix — exact clone with all hierarchy levels pinned open via expansionStates

  • Two action buttons — "Expand All" shows the expanded matrix, "Collapse All" switches back

  • Two bookmarks — pure visibility toggles with suppressData: true (no filter side-effects)

  • Bookmark group — registered in bookmarks.json so the toggle pair stays organized

Tool Information

Price

20 USD

Category

Build

Version

Version 1.0.0.2.13