Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |