Forum Discussion
Solved
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 an...
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!