#HOW TO DELETE A HEADER LINE HOW TO#

Now we have to merge some rows, so we get the full desired header. This will make Power BI remove the top number defined on the step вЂњRows to RemoveвЂќ. Insert another step after вЂњBack to Original StateвЂќ and rename it to вЂњRemoving top N rowsвЂќ and type the below command. Rename it to вЂњBack to Original StateвЂќ and in the command section, change it to: Right click the вЂњRows to removeвЂќ step and select вЂњInsert step afterвЂќ. Still in this step, add вЂњвЂќ in the end of the command and rename this step to вЂњRows to removeвЂќ. Now select the Index column at the end of the table, right click it and select вЂњRemove other ColumnsвЂќ: So, weвЂ™ll filter for the column 3 for the rows containing вЂњEnergyвЂќ (you could filter using any of the columns, as long as you end up with the row where the header should start): The top row that we want as a header, is the one containing Date, Education, Energy, Gas, Rent, etc. Now you filter any of the columns, so you end up with the top row that contains some of the header information.

Right click on the last step on the Applied Steps section and select Insert Step After.Д¬reate a new index column, starting from 0

#HOW TO DELETE A HEADER LINE HOW TO#

Select the Sheet 1 (even though there are suggested tables, in this case, the aim is to learn how to do this by yourself) and click on Transform Data. Open a new Power BI file and choose to get data from an Excel file. Have you ever been in a situation that you have an excel file with nested column headers, and you want them to be correctly ingested in your dashboarding tool?ДЄnd to make it more difficult, these headers are not at the top of the sheet, theyвЂ™re in the middle, and theyвЂ™re not always in a specific row number. Do you know how to dynamically delete multiple header rows in Power BI?ДЇollow along to the video or check out the steps below.

How to delete a header line