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.
I hope some can help. I have an excel sheet that has the a list of the months 1-12 as the header for the columns. In power-bi i have a table to that the months in the rows. Is there anyway to map the query of the excel data base to the query of the month table. The data below the list of months is the revenue for that item in that month. In normal mapping it will attempt to map the data in the cell and not the data in the header. Please help!!!
Solved! Go to Solution.
In Power BI desktop, once you import the data from Excel, it sounds like you'll want to unpivot the month columns. That will give you the months in rows.
It's always easier to give more specific help if you provide sample data.
Hi @chadb,
ssugar 's answer is helpful. Please have a try.
If you want to unpivot your month colunm from column to row, you could refer to this blog about unpivot.
If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and your desired output so that we could help further on it easier.
Best Regards,
Cherry
In Power BI desktop, once you import the data from Excel, it sounds like you'll want to unpivot the month columns. That will give you the months in rows.
It's always easier to give more specific help if you provide sample data.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |