Forum Discussion
tylerdv
9 years agoFrequent Visitor
Rows not columns
Hey all! New PowerBI desktop user here. I am currently working on reporting for sales and conversions. My big issue is all my data runs the opposite way that PowerBI likes. adding new data to co...
- 9 years ago
MarcelBeugis correct. You will need to transpose the information in PowerQuery. Thankfully, you only have to do it once and it will continue to run.
Check out this video for a tutorial:
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-5-cleaning-irregular-data/
MarcelBeug
9 years agoCommunity Champion
In the Query Editor - tab Transform - Transpose