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

Multiple Header Column

Hi,

 

I'm just using Power BI Desktop for the first time, I have a problem if in my excel file has multiple header like this:

PowerBI_1.PNG

 

After I load into PowerQuery, it looks like this.

PowerBI_2.PNG

 

  1. PowerQuery don't have feature Merge & Center like Excel, any solution for my problem ?
  2. and I want the visualization can filter "In January B for Category KLM what is the SUM" is it possible ?

Thanks a lot!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Multiple Header Column

@ikrisna,

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473

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

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Multiple Header Column

Hi,

 

You may refer to my solution here - Rearrange a multi heading dataset into a single heading one which is Pivot ready.  Please check both workbooks at that link.

 

Hope this helps.

ikrisna Frequent Visitor
Frequent Visitor

Re: Multiple Header Column

Hi Ashish,

 

Thanks, so far it works for my dummy data! Smiley Happy

Unfortunately I couldn't access due to permission issue on the second workbook.

 

Thanks

Super User
Super User

Re: Multiple Header Column

Hi,

 

You are welcome.  I guess you mean that you cannot download the second workbook.  Please try to download from your Home internet connection.

Community Support Team
Community Support Team

Re: Multiple Header Column

@ikrisna,

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473

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

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 274 members 2,776 guests
Please welcome our newest community members: