Forum Discussion
cyberphew
8 years agoRegular Visitor
Sales matrix without hierarchy
Hi, I am very new to Power BI and I am trying to create a matrix displaying sales totals for different customers. What I want to achieve is something like this: each record in my datase...
v-yulgu-msft
8 years agoMicrosoft Employee
Hi cyberphew,
Once you add multiple fields in Row section or Column section of Matrix visual, it will be shown in hierarchy format automatically. It is not allowed to disable this behavior currently.
To achieve your desired output, after adding all relative fields into Matrix, please click the third drill down option for three times. Besides, turn off the "Stepped Layout" option under the Row headers menu.
Best regards,
Yuliana Gu