Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

importing data from excel

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 skippi...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous   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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous   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