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