Disable Expand/collapse option in matrix Power BI

[Ronak_1]

Can we disable Expand/collapse option in matrix Power BI?

[PijushRoy · Accepted solution]

Hi @Ronak_1 

Expand and Collapse option for dirll down and drill up. If you not looking for DrillDown and DrillUp, please use normal table in place of Matrix visual.
For row hierarchy, you can create Hierarchy level in your data and use in simple table visual
But dont think, there are any option to remove Expand and Collapse, options are how it was build.

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Idrissshatila · Accepted solution]

Hello @Ronak_1 ,

this is a part of the visual options, you can't remove it.

as @PijushRoy  mentioned, you could either use the table visual or don't include a heirarchy.

[Anonymous · Accepted solution]

Hi @Ronak_1 

Just as @Idrissshatila and @PijushRoy (Thanks for your all contribution to the Forum) said that the Expand/collapse option in matrix can not be hidden.

Or maybe you can try to consider using a table visual instead of a matrix. The table visual doesn't have the expand/collapse behavior, making it a straightforward alternative.

Best Regards

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

[Idrissshatila · Accepted solution]

Hello @Ronak_1 ,

this is a part of the visual options, you can't remove it.

as @PijushRoy  mentioned, you could either use the table visual or don't include a heirarchy.

[Charles_29]

Hello, i am using a column selector by using the field parameters. Basically this table matrix is giving the user to flexibility on the data they want to see. The problem that i am encountering is if i select more columns on the selector it requires me to expand the data. That's the step i want to remove. Whenever i select other columns its already expanded.

[PijushRoy · Accepted solution]

Hi @Ronak_1 

Expand and Collapse option for dirll down and drill up. If you not looking for DrillDown and DrillUp, please use normal table in place of Matrix visual.
For row hierarchy, you can create Hierarchy level in your data and use in simple table visual
But dont think, there are any option to remove Expand and Collapse, options are how it was build.

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Charles_29]

Hello, i am using a column selector by using the field parameters. Basically this table matrix is giving the user to flexibility on the data they want to see. The problem that i am encountering is if i select more columns on the selector it requires me to expand the data. That's the step i want to remove. Whenever i select other columns its already expanded.