cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How make nth row as header in Power BI desktop ?

Hi All,

 

 

I need help in a case where i have to make nth row as header.

sample.pngthis want i want to do in power bi desktop

Regards,

Satish

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: How make nth row as header in Power BI desktop ?

Hi @Satish_Kumar,

Please select the value->click "Format as table"(highlighted in bule line), and give the table a name(please review the highlighted red line in second screenshot).

1.PNGpicture12.PNGpicture2
Then when you get date from the excel, the table will be listed there, you just select the table and use the first row as Headers. You will get expected result as follows.

3.png4.PNG

Best Regards,
Angelia

4 REPLIES 4
Super User
Super User

Re: How make nth row as header in Power BI desktop ?

Typically, you would do a Remove Rows and remove the top rows (4) and then promote your header row.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-huizhn-msft Super Contributor
Super Contributor

Re: How make nth row as header in Power BI desktop ?

Hi @Satish_Kumar,

Please select the value->click "Format as table"(highlighted in bule line), and give the table a name(please review the highlighted red line in second screenshot).

1.PNGpicture12.PNGpicture2
Then when you get date from the excel, the table will be listed there, you just select the table and use the first row as Headers. You will get expected result as follows.

3.png4.PNG

Best Regards,
Angelia

dems1bb4 Frequent Visitor
Frequent Visitor

Re: How make nth row as header in Power BI desktop ?

so I need to do that in Excel already, understood.

is there any other way to do it in PBI without deleting the rows above the row that shall be my Headerrow?

 

Highlighted
wottel Frequent Visitor
Frequent Visitor

Re: How make nth row as header in Power BI desktop ?

Not an elegant solution but you can repeat the "Use First Row as Headers" until the desired row is promoted

Multiple Header Promotioins.JPG