cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chadb Frequent Visitor
Frequent Visitor

map to column header

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!!! 

1 ACCEPTED SOLUTION

Accepted Solutions
ssugar Member
Member

Re: map to column header

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.

View solution in original post

2 REPLIES 2
ssugar Member
Member

Re: map to column header

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.

View solution in original post

Community Support Team
Community Support Team

Re: map to column header

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors