Forum Discussion

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

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.