Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Peter_
Resolver I
Resolver I

Matrix - collapse all rows?

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

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Peter_ ,

 

If you right click the column(s) where you have the +/- you can colapse or expand selection, entire level or all:

 

rigthclickmatirs.png

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português





View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

Hi @Peter_ ,

 

If you right click the column(s) where you have the +/- you can colapse or expand selection, entire level or all:

 

rigthclickmatirs.png

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português





Hi 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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português





Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors