Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

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

5 REPLIES 5
Anonymous
Not applicable
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

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.
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi Ashish,

 

Thanks, so far it works for my dummy data! 🙂

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

 

Thanks

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors