Forum Discussion

christ7's avatar
christ7
Frequent Visitor
6 years ago
Solved

Two data rows per subject in matrix

Hello, any help is appreciated.

I currently have this layout in Excel and tried to replicate in Power BI but not sure how to get it right. I have x number of subjects/names in the first column and the other column headings or certain variables. In Excel, you can see for every subject/name there is a right and left under the direction column, so 2 rows of data.

How do I get this in Power BI so the second column will be 'direction' then the left and right score in 2 rows for each name/subject?

 

Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    6 years ago

    Hi christ7 ,

     

    Do you have a column with the LEFT and RIGHT values? if yes just place this column within the rows so you will have name / Direction and then drill down you matrix to the lowest level.

     

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi christ7 ,

     

    Do you have a column with the LEFT and RIGHT values? if yes just place this column within the rows so you will have name / Direction and then drill down you matrix to the lowest level.

     

    • christ7's avatar
      christ7
      Frequent Visitor
      6 years ago

      Thank you, Miguel.

      But when I add the direction (left/right) into the rows and click drill down I don't get anything. 

       

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi christ7 ,

     

    Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.