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. PowerQuery don't have feature Merge & Center like Excel, any solution for my problem ?and I want the visualization can filter "In January B for Category KLM what is the SUM" is it possible ?Thanks a lot!

Anonymous, You may take a look at the post below. https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473

Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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.

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

Thanks a lot!