Forum Discussion

jnn4282's avatar
jnn4282
Helper II
4 years ago
Solved

Unvipoting columns

https://we.tl/t-yjVsqZaXm3 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 desi...
Need Help
  • Seanan's avatar
    Seanan
    4 years ago

    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.

Seanan's avatar
Seanan
Solution Supplier
4 years ago

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.

  • jnn4282's avatar
    jnn4282
    Helper II
    4 years ago

     

    I hope you can figure it out. Its so small though

    • Seanan's avatar
      Seanan
      Solution Supplier
      4 years ago

      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.

      • jnn4282's avatar
        jnn4282
        Helper II
        4 years ago

        I found the cause as per your instruction and managed to solve the problem.

        Thanks and big KUDOS Seanan