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
I am new to Power BI and I have watched a handful of tutorials but cant seem to find a good one on various excels (mainly the formatting). The excels I keep have the months across the horizontal axis and measures we track down the vertical axis. I am having a hard time building reports with my data formatted this way in Power BI. I expirmented moving my data and having the months down the vertical axis and measures on the horizonal axis and had better luck. Is there anyway to keep my data in the format it is so I dont have to copy/paste all of my data in a new format? I hope that makes sense. Thanks!
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 5 | |
| 4 | |
| 4 |