Two data rows per subject in matrix

[christ7]

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?

[v-frfei-msft]

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.

[MFelix · Accepted solution]

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]

Thank you, Miguel.

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