importing data from excel

[neelofarshama]

Hi,

I have data in my excel shown below, when I import it into Power BI, it is showing the row headers as values, which is wrong I tried using "Mark first row as header" option but then it is skipping the total for all columns.

Power BI:                                                                                                               

          

Power BI with row as header:

Please help me to load the data

Thanks in Advance

[Anonymous · Accepted solution]

Hi @neelofarshama   you will have to select the three columns and unpivot the data to get the desired result...

and then use matrix

Please accept this as solution if this helped you