Convert Table (with dates as columns) to Line Chart

[EH_MW]

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

[jgeddes · Accepted solution]

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.

[EH_MW]

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.

[fahadqadir3]

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