Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Disable Drill down/expand option in matrix visual



I am working on a Matrix visual and have fields like EmpID, Name, TeamLead, Manager, Senior Manager in rows and in columns i want values as week numbers. I want these fields in separate columns rather using in hierarchy(In short, I want rows like i get in Table visual).

Please suggest how to do this.

Note: I have already browse on internet and tested the solution which says disable it from Format>Visual Header>Drill Up Icon and Show Next level Icon. This solution is not working for me.

Gaurav Jangra

Resolver II
Resolver II

of the following 2 options in the row header

Format ->Row Headers->Sprpped Design (Off) and +/- Icon (Off)

View solution in original post

Community Support
Community Support

Hi @Anonymous ,


As sreenub's suggeation, there are more details to add. You may selec on this Matrix visual, go to Format section ->Row headers, turn off the option "Stepped layout ".













For reference:

7 Secrets of the Matrix Visual


Best Regards,



Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Resolver II
Resolver II

of the following 2 options in the row header

Format ->Row Headers->Sprpped Design (Off) and +/- Icon (Off)

Not applicable

using Power BI 2.104.941.0, looking for "Sprpped Design" referenced above. Does this mean "stepped layout?" I disabled it and the +/- icon. The "expand" button is gone, but the rows are not showing.

Same - I do not want to show the drill down nor the icons but I would like to see more than one column on the grid.  


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors