Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you, Miguel.
But when I add the direction (left/right) into the rows and click drill down I don't get anything.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |