Forum Discussion

jnn4282's avatar
jnn4282
Icon for Helper II rankHelper 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
Icon for Solution Supplier rankSolution 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
      Icon for Solution Supplier rankSolution 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
        Icon for Helper II rankHelper II
        4 years ago

         

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