Forum Discussion
Promoting headers that don't match
Hi mwvoves
I've attached a PBIX file for you.
Firstly, you want to Transpose the table (in the Transform tab of Power Query), then Unpivot.
You will have to delete your second Applied Step though, as Power BI is automatically determining your first header.
Let me know whether the attached is what you are after. The outputs turn out like this:
Hope this helps!
Theo 🙂
Here's how the table loads into power BI- are you saying I should unpivot the table as is (instead of removing the top 2 rows/promoting the first row as headers)?
Hi mwvoves
I've attached a PBIX file for you.
Firstly, you want to Transpose the table (in the Transform tab of Power Query), then Unpivot.
You will have to delete your second Applied Step though, as Power BI is automatically determining your first header.
Let me know whether the attached is what you are after. The outputs turn out like this:
Hope this helps!
Theo 🙂
Yes I was able to get it to work after using the transpose step, thank you!!