Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I would like to unpivot a table; but I can't seem to easily unpivot after following a couple of tutorials. I suspect it has to do with the data as it is, I think I need to clean it up some more.
Here is what I have in Power BI right now and what I'd like it to look like:
Basically, for every course an employee has a record of (the non-null values), I would expect a row, with the Course Name and corresponding information, such as Grace Period, Frequency and Priority.
Any help will be greatly appreciated. 🙂
Solved! Go to Solution.
1) Select Employee Name, Employee Number and Column 2 - Unpivot Other Columns
2) Select Column 2 - Pivot Column - Values Column select Value - Don't Aggregate
3) Rename Attribute Column (rearrange columns if you want)
Hope this helps!
Can you please provide some sample data? Typing everything from your screenshot is not fun...
Sure!
Here is an example of what I brought in from Excel (a matrix). The first two columns came in as one but I split them in Power BI, so there is the name and employee number now.
Employee Name | Employee Number | Column2 | 010.100 development…etc | 020.200 development…etc | 500.100 course xyz name | 020.200 development…etc |
Anderson, Jesse | 123 | Frequency | 36 | 12 | 12 | 24 |
Anderson, Jesse | 123 | Priority | 1 | 3 | 5 | 1 |
Anderson, Jesse | 123 | Grace Period | 365 | 90 | 60 | 365 |
Here is where I want to get to so I can build my visualizations:
Course Name | Employee Name | Grace Period | Frequency | Priority |
010.100 development…etc | Anderson, Jesse | 365 | 36 | 1 |
020.200 development…etc | Anderson, Jesse | 90 | 12 | 3 |
500.100 course xyz name | Anderson, Jesse | 60 | 12 | 5 |
020.200 development…etc | Anderson, Jesse | 365 | 24 | 1 |
Something tells me the third column ( in original) is what it's not liking, Column2. I feel like that is what is throwing off the unpivot option and need to break this down into more than one step to get it right.
Thanks for your prompt response! 🙂
Got it:
Done!
1) Select Employee Name, Employee Number and Column 2 - Unpivot Other Columns
2) Select Column 2 - Pivot Column - Values Column select Value - Don't Aggregate
3) Rename Attribute Column (rearrange columns if you want)
Hope this helps!
Wow! Thank you!!! I knew it had to be a two-step "something" but just couldn't figure it out. I met with someone here at work yesterday for close to an hour and they couldn't figure it out. 😞
Amazing! Thank you!!! Loving the help and support in this community and looking forward to sharing with others! 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |