Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi,
I searched how to transpose column and row but I didn't find. Can anyone know how to do it?
I saw an old post on this forum about it but the solution don't work for me.
Indeed my column are calculated column so I can't use power query.
I put a screen of the old topic it will help you understand what I would like to have.
Thank you
Best regards
Solved! Go to Solution.
@Anonymous
You should reconsider those columns to be created in PQ or try to achieve your results using Measure.
But, Unpivoting is possible though:
https://www.youtube.com/watch?v=9Xv8COs59tc
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You should reconsider those columns to be created in PQ or try to achieve your results using Measure.
But, Unpivoting is possible though:
https://www.youtube.com/watch?v=9Xv8COs59tc
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you!
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 20 | |
| 19 | |
| 11 |
| User | Count |
|---|---|
| 66 | |
| 56 | |
| 46 | |
| 44 | |
| 31 |