Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |