Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
62 | |
61 | |
60 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |