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.
Hi can anyone give some advice on how to import a cross tab formatted table from Excel into Power BI so it can be used to create new visualisations please?
i.e.
State 1999 2000 2001 2002
Vic 10 5 7 23
NSW 15 6 3 43
QLD 34 12 52 7
Solved! Go to Solution.
@Space You can load the data as is, then once it is loaded, go to Edit Queries, select all the year rows, right click and select Unpivot Columns, this will pull all the years into a single column and the values corresponding to them. I assume this is the output you expect.
Hi @Space,
Have you resolved your issue? If so, please kindly mark the corresponding reply as an answer so that some other users can find the solution more easily. If you still have any question, please feel free to ask.
Best regards,
Yuliana Gu
@Space You can load the data as is, then once it is loaded, go to Edit Queries, select all the year rows, right click and select Unpivot Columns, this will pull all the years into a single column and the values corresponding to them. I assume this is the output you expect.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |