Multiple Header Column

[Anonymous]

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:

After I load into PowerQuery, it looks like this.

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!

[Anonymous]

Hi,

The below video can help you.

(7799) Dealing with DOUBLE HEADERS in Power BI using UNPIVOT, TRANSPOSE, and FILL DOWN - YouTube

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may take a look at the post below.

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

[Ashish_Mathur]

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.

[Anonymous]

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

[Ashish_Mathur]

Hi,

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