Forum Discussion
Solved
Matrix in Power BI drop-down behavior
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 |
6 Replies
Hi Sayesd ,
On the options search for Stepped Layout and turn it off.
If you want there is also an option to turn off the +/-.
