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

  • vijayghatti's avatar
    vijayghatti
    Frequent Visitor
    9 years ago

    Thank you for the help.

     

    i was able to do the things as per the steps explained, how ever let me try to explain the senario.

     

    i have a view which has the metadata that is required for the report and a table which has the list of projects, both are from SQL server.

    now i imported the data and followed the steps as said, but i am not able to show the output in the way that was desired to be.

     

    .

     

    screenshot 3 is the expected format and also i need to show the percentage of values in another column.

    hope this clarifies.

     

    thanks

    Vijay

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      Hi vijayghatti,

       

      So, image1 is what you get after "Unpivot" table, right? Now, you want to create a visual displayinglike image3 based on image1 table, right?

       

      Would you please elaborate the structre of your desired output, having row group/column group, or hierarchy? And how do you want to calculate the percentage value?

       

      Regards,
      Yuliana Gu