Each month in a single column. How to group?

[nsuvorov]

Hi all,

Table is presented by a column with employees and 12 columns for months. Data in months cells. So view is:

Row1: Employee|Jan|Feb...

Row2: Nikolay|123|32...

RowN...

A question is how to group data by months if I wanna get a chart for ex where each line will be an employee, X - month, Y - value?

Thanks a lot! Cheers!

[Greg_Deckler · Accepted solution]

I would recommend taking your query, selecting your month columns and choosing to "Unpivot Columns". Then, you can use a table visualization to get what you want. Unpivot columns is found on the transform tab.

[nsuvorov]

Great! Exactly what was needed. Only thing it was nessesary to delete a folder "C:\Program Files\Microsoft Power BI Desktop\bin\ru" -- it let me see the button you pointed. Many thanks!

[hohlick]

In russian version of PowerBI Desktop this option has name "Отменить свертывание столбцов".

You also can use select first column and apply "Unpivot Other Columns" ("Отменить свертывание других столбцов")