Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I want to tranpose horizontal data in vertical form. Please find the input that i have.
Output that i require.
Solved! Go to Solution.
Hi, I have just simulated your data except the Project names. Here is the image of the result. (Please note that I have created a Conditional Column in the PQE to sort the months).
You can download the file on which I have worked here:
Unpivot and Transpose with SortColumn Sample.pbix
If this sample is found to be helpful, please accept it as a solution which could help others too. Your Kudo's are welcome.
Best,
C.S.N. Raja
Hi, I have just simulated your data except the Project names. Here is the image of the result. (Please note that I have created a Conditional Column in the PQE to sort the months).
You can download the file on which I have worked here:
Unpivot and Transpose with SortColumn Sample.pbix
If this sample is found to be helpful, please accept it as a solution which could help others too. Your Kudo's are welcome.
Best,
C.S.N. Raja
would you please share the sample data here
Hi, I had provided the link in my reply. Hope you are able to download the PBIX file. Please check and confirm.
can download power bi file. need to see actual raw data that you have created. so i can manage my accordingly. thanks for your help
As I said, I have just simulated your sample data in an Excel sheet. Here is the image of my excel table:
If the suggestions provided by me are useful, please consider "Accept" as a solution.
Best,
C.S.N. Raja
Thank you very much both of you ... both solution works very wells 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |