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 desired result.

Would you

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.

10 Replies

  • Seanan's avatar
    Seanan
    Solution Supplier
    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.

    • jnn4282's avatar
      jnn4282
      Helper II
      4 years ago

      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

      • Seanan's avatar
        Seanan
        Solution Supplier
        4 years ago

        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.

  • Seanan's avatar
    Seanan
    Solution Supplier
    4 years ago

    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.

      • 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.