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.
I want my data below to display two columns, one for Attainment grade and another for Effort grade so that I can treat them as independent data types. Any suggestions on how best to achieve this? The only thing I can come up with is to copy the huge table (there are over 20 columns) two times, filter one to display "Attainment grade" and the other to display "Effort grade" only in the query editor and then join them via a relationship, this feels really messy, so I want a better approach to this.
Solved! Go to Solution.
hi,
you can use "Pivot" transformation in Power Query.
Here is the PBI file.
hi,
you can use "Pivot" transformation in Power Query.
Here is the PBI file.
Thank you that is great! I am curious why did you bother with adding the index column?
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |