Each column is a Date - How to make them show up as a linear time in line chart?

[Pandetbaby]

He

Hey everyone!

I want to establish values over time, it's probably simple but I am struggeling. 

The data set I get sent has a column with Customer ID's and then the following columns are the values attributed to them. Each week a new column is added. 

E.g. 

Customer       Week 1        Week 2         Week 3 

A                       10                  8                  20

B                       15                 11                  11

What I am struggeling with is tht I can only manage to display them as individual values in a vertical line, when I need them to be sequential on a horizontal to show movement over time.

Appreciate any help!

[Anonymous · Accepted solution]

you should select the week columns in power query and select in the transform menu the unpivot option. This should give you the desired result

[Pandetbaby]

That worked!
Thank you!