Forum Discussion
How to use a mid-table row as the column headers, while still keeping the above table rows
Good day everyone! I am relatively new to Power Bi Desktop and am hoping for answers to my current problem. I've imported data from an Excel Workbook and am now trying to format my data. I've...
Idrissshatila
Super User
Super UserAnonymous Can you show me the advanced editor in the table you want to adjust the headers and the number of row you want to make the header.
copy past here the code in the advanced editor to here
- Idrissshatila
Anonymous ,
in the last row after the "in" replace the #"Changed Type" with #"Promoted Headers"
No dice, unfortunately.
- Idrissshatila
Anonymous , replace the promoted header line with this
#"Promoted Headers" = Table.PromoteHeaders(Table.Skip(#"Changed Type",1), [PromoteAllScalars=true])