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.
Greetings,
I'm bagging my head against the wall trying to transpose/pivot my data. Here's my dataset below:
Sales ID | Ticket 1 | Ticket 2 | Ticket 3 |
1 | Funny | null | null |
2 | Happy | Serious | null |
3 | Fun | Ugly | Vanity |
What I'm trying to do in my table is this:
Sales ID | Ticket |
1 | Funny |
2 | Happy |
2 | Serious |
3 | Fun |
3 | Ugly |
3 | Vanity |
Does anyone know how I do this in Power BI, I did it before but was a long time ago?
Solved! Go to Solution.
Power Query. select 1st column. Right-click. Unpivot other columns
Power Query. select 1st column. Right-click. Unpivot other columns
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 | |
105 | |
79 | |
69 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |