Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I need help in a case where i have to make nth row as header.
Regards,
Satish
Solved! Go to Solution.
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).
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.
Best Regards,
Angelia
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).
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.
Best Regards,
Angelia
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?
Not an elegant solution but you can repeat the "Use First Row as Headers" until the desired row is promoted
Typically, you would do a Remove Rows and remove the top rows (4) and then promote your header row.
Excellent solution.
First remove the 1st Row and then Promote the row as headers.
Thankyou Greg
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |