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 in Power BI by Roshni
• 3,830 points
3,665 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.

answered Feb 3 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 3 in Power BI by ggm
• 140 points
236 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,010 points
615 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28, 2019 in Power BI by Cherukuri
• 32,490 points
106 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,490 points
8,133 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
• 32,490 points
137 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4 in Power BI by Roshni
• 3,830 points
71 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 in Power BI by Gitika
• 37,370 points
1,056 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 in Power BI by Gitika
• 37,370 points
547 views
+3 votes
1 answer

How to replace null values with custom values in Power BI(power query editor)?

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

answered Mar 8, 2019 in Power BI by Cherukuri
• 32,490 points
34,549 views
0 votes
1 answer