The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Thanks a lot!
Solved! Go to Solution.
@Anonymous,
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473
Hi,
The below video can help you.
(7799) Dealing with DOUBLE HEADERS in Power BI using UNPIVOT, TRANSPOSE, and FILL DOWN - YouTube
@Anonymous,
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473
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.
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.