Data Transpose

[vijayghatti]

Hello friends,

can you please help me on how to translate the data shown below

Project                     Area1                     Area2                 Area3

P100                        22500                      2200                     45000

T010                        4500                         37000                   480000

to

Area1          22500

Area2            2200

Area3            45000

filtered by Project.

[v-yulgu-msft]

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]

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]

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

[vijayghatti]

Thanks for the quick revert.

can you please check the screenshots and help

[MarcelBeug]

Awaiting your screenshots...

[MarcelBeug]

In the Query Editor, choose your Project column, right-click and select "Unpivot Other Columns".