Forum Discussion

EH_MW's avatar
EH_MW
Helper I
2 years ago
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...
Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

    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.

jgeddes's avatar
jgeddes
Super User
2 years ago

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's avatar
    EH_MW
    Helper I
    2 years ago

    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's avatar
      fahadqadir3
      Solution Supplier
      2 years ago

      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!