How to demote Headers in Power BI query editor

0 votes
Can anyone explain how to demote headers in Power BI query editor?
Feb 3, 2020 in Power BI by Roshni
• 10,480 points
19,383 views

1 answer to this question.

+1 vote

Hi,

There are the steps which you can follow to demote any Header, let;s go through:

  1. Import excel files into power BI (load the data).
  2. Click on Home-> (right hand side) use first row as header-> use header as first row.
  3. Click on Transform Ribbon-> transpose.
  4. Right click on Column-> transform-> Trim.
  5. Transpose again.
  6. Again go click on home-> use first row as header-> Replace Value.

Using these steps you will be able to demote any header you want.

I hope these will be helpful for you. 

If you are interested in learning Power BI then check out Power BI Course Details now!

answered Feb 3, 2020 by Jitesh

Related Questions In Power BI

0 votes
0 answers

How to group rows in Power BI query editor?

Can someone explain the steps how can ...READ MORE

Feb 4, 2020 in Power BI by ggm
• 140 points
1,295 views
0 votes
1 answer

How can I ensure the data types in Power Query are maintained when moving to the Power BI Data Model?

Follow these practices in order to preserve ...READ MORE

answered Dec 23, 2024 in Power BI by pooja
• 12,450 points
149 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
3,061 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
1,455 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6, 2024 in Power BI by anonymous
• 1,420 points
1,027 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,770 points
12,395 views
0 votes
1 answer

How to make a table Hyperlink in Excel Power Pivot?

Hey, You can follow these steps to make a ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,770 points
6,504 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
79,419 views
+2 votes
3 answers

How to replace null values in Power BI ?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
161,714 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP