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...
Hi MFelix , thank you for resposding but I did what you said but its not helping me. Its still hirarchy mode.
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.
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