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...
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 |