Matrix in Power BI drop-down behavior

[Sayesd]

When you add the "ProductName", "ProductID", and "Address" fields to the Rows section of the Matrix visual, by default, Power BI will treat them as hierarchical levels and display them with a drop-down behavior. This means that when you have multiple values for these fields, they will be grouped and displayed with a "+" or "-" icon to expand or collapse the groups. How to remove this drop-down behavior and show all the unique combinations of "ProductName", "ProductID", and "Address" as individual rows?

I want to show the matrix like this

ProductName	ProductID	Address	1 - 10	11 - 20	21 -30	31 - 40
A	12	3245 A st	$12	$54	$34	$21
B	32	1123 B st	$65	$34	$27	$98

[MFelix]

Hi @Sayesd ,

On the options search for Stepped Layout and turn it off.

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#stepped-layout-with-matrix-...

If you want there is also an option to turn off the +/-.

[Sayesd]

Hi @MFelix , thank you for resposding but I did what you said but its not helping me. Its still hirarchy mode. 

[MFelix]

Hi @Sayesd ,

Do you have more than one Product name each Product? How is the result you are achieving? Have you tried using a simple table?

Without data is difficult to give you the correct answer since the modelling and the table columns and measure change the result you may have.

[Sayesd]

@MFelix the data that I give is sample data 

The result table is showing.

ProductName	1 - 10	11 - 20	21 -30	31 - 40
+A	$12	$54	$34	$21
+B	$65	$34	$27	$98
+C	$43	$12	$98	$53
+D	$87	$96	$45	$97

Expected table

ProductName	ProductID	Address	1 - 10	11 - 20	21 -30	31 - 40
A	12	3245 A st	$12	$54	$34	$21
B	32	1123 B st	$65	$34	$27	$98
C	43	23 E st	$43	$12	$98	$53
D	56	54 B st	$87	$96	$45	$97

[MFelix · Accepted solution]

Hi @Sayesd ,

If you click the + button you will opewn the hierarchy has you need in the example below I have turn off stepped layout and +/- buttons the drill can also be done using the buttons highlithed

[Sayesd]

Thank you @MFelix, your answer solved my problem.