This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi,
Is there an easy way to collapse all rows in Matrix chart with "+/- icons" rather than manually clicking on "-" icon next to each expanded row?
Thanks
Solved! Go to Solution.
Hi @Peter_ ,
If you right click the column(s) where you have the +/- you can colapse or expand selection, entire level or all:
This works with any number of levels you may add to your matrix, and on stepped and non stepped layout.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Peter_ ,
If you right click the column(s) where you have the +/- you can colapse or expand selection, entire level or all:
This works with any number of levels you may add to your matrix, and on stepped and non stepped layout.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Miguel.
Thank you very much for the solution to this question.
Is there a way to do this without right-clicking the symbol?
Like in a button or an option visible to the web user?
Thanks.
Hi @danielcvs,
On the icons on top of the visual you have 4 buttons
Arrow pointing up - goes to the top level
Arrow pointing down - turns on click on mouse to drill down
Two arrows - go to next level (does not show higher level)
One splitting arrow goes to the last level
This should help you.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 26 | |
| 23 | |
| 22 | |
| 13 |
| User | Count |
|---|---|
| 62 | |
| 47 | |
| 27 | |
| 23 | |
| 19 |