Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live 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 |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 135 | |
| 109 | |
| 57 | |
| 43 | |
| 38 |