Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
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!
In russian version of PowerBI Desktop this option has name "Отменить свертывание столбцов".
You also can use select first column and apply "Unpivot Other Columns" ("Отменить свертывание других столбцов")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |