Forum Discussion
Convert Table (with dates as columns) to Line Chart
Hello,
I am provided data in the following format:
Categories are the first column.
Each individual month is then listed as its own column.
And the values are monetary values for each category and month.
The customer wants a line chart, displaying this same data. However, since each month is its own column, I cannot simply use a "date" column as the X-axis. Can you tell me how to accomplish this? Am i having a case of the Mondays?
Thanks!
Matt
The best way to accomplish this is to unpivot the month columns in Power Query. That will turn your twelve month columns into a column with the date and a column with the coresponding value for that month. The date column can then be used in a visual as you need.
3 Replies
The best way to accomplish this is to unpivot the month columns in Power Query. That will turn your twelve month columns into a column with the date and a column with the coresponding value for that month. The date column can then be used in a visual as you need.
Thanks. That's the route I thought I might have to go, but wanted to be sure I wasn't missing something simple before heading down that path.
EH_MW Unpivot the months column in Power Query and then use the month as X-Axis
Regards,
Fahad Qadir
Did I answer your question? Mark my post as a solution!
