Forum Discussion

vijayghatti's avatar
vijayghatti
Frequent Visitor
9 years ago

Data Transpose

  Hello friends,   can you please help me on how to translate the data shown below   Project                     Area1                     Area2                 Area3   P100                   ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi vijayghatti,

 

In query editor mode, select [Project] column, then, unpivot other columns.

 

 

To filter data by project, you only need to insert column [Project] into slicer.

 

If you still have any question, please feel free to ask.

 

Best regards,
Yuliana Gu