how to make 2 rows as Headers in Power BI

[Anonymous]

Hello All, 

I have to create few visualizations where I have to use two of the rows as headers.  I can't find a solution to treat 2 rows as Headers together. My data source is an excel sheet. I am uploading the sample data source to have a look. 

I have to create a bar chart for Actual and target for every department. like in 1st header for lean 2 bars for actual and target like this. 

Thanks 

@MFelix 

@Jihwan_Kim 

@Greg_Deckler 

[partymia]

When you go to Transform data, there is a button that you can click and select use first rows as headers:

And i beleive once you select it, you can specify if a column is not needed. Alternatively if you already remove all the once you dont need in excel and simply connect the file with the top row that you need should solve your issue.

[Anonymous]

@partymia I need 2 rows at a time as headers 

[partymia · Accepted solution]

If this is going to be a data source you use regularly it could be easiest to simply concatinate the two headers together. So you will have them in 1 row. Alternatively, some articles which might help dealing with 2 rows as headers: link1 and link2

Hope this helps.