Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I wonder if there is any possibility of unpivoting my columns as follows.
Want to be like this ↓
I tried a lot in Power BI but was unable to get the desired result.
Would you
Solved! Go to Solution.
Hi @jnn4282
Under the Home tab click transform data -> hold CTRL and left click on all of your date columns (Jan-Dec) -> Right click and select unpivot columns.
Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.
Hi @jnn4282
It seems like pivoting the acc_title column has caused some mismatch data types. Could you please take a picture of your PL table.
Hi @jnn4282
Unfortunately, I am unable to view the data in your report as the data source is coming from your hard drive (DataSource.Error: Could not find a part of the path)
Could you please take a picture of your PL table from within the transform data view.
I hope you can figure it out. Its so small though
Hi @jnn4282
I've managed to figure out where the errors are coming from. If you click tranform data and in your PL table scroll to the far right until you find the Net Profit column. Right click the column and select remove errors (These rows won't matter as it seems like there is no data stored for these rows so they have no value).
Click apply and close and your data should load without any errors now.
Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.
I found the cause as per your instruction and managed to solve the problem.
Thanks and big KUDOS @Seanan
Hi @jnn4282
Under the Home tab click transform data -> hold CTRL and left click on all of your date columns (Jan-Dec) -> Right click and select unpivot columns.
Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.
Hi Seanan,
Thank you for your prompt response. Month and Value were fine with this way. But my desired result is as per the excel pivoted sheet. Please download it and see it for me. I want Acc_Title as the header
Hi @jnn4282
After unpivoting the month columns, click on your acc_title column and select pivot column (under the home tab in transform data), set the values column to the value column containing the monthly numbers and set the advanced options to "Don't Aggregate". This will then give you the result you are looking for.
Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |