Issues with dates in Columns

[Anonymous]

hi

I have no idea how to create a dashboard with dates in columns. I have a demand by SKus per week, into the file my dates are located in the column and rows with the number.

I need a line chart or clustered column chart showing the demand per week. X axis the dates or weeks and Y axis the demand.

10/30/2018	11/6/2018	11/13/2018	11/20/2018
9	40	40	60
288	510.02976	144.0004	468.17752
18	84	12	60
40	160	24	120
12	3	15	69
103	243	139	229

I have problems to modelling this graphic.

thanks for your help

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Select all columns and unpivot.

Place [date] onto Axis and [demand] in Value.

Best regards,

Yuliana Gu

[Anonymous]

Hi @Anonymous

This table structure won't work because the columns seem to have different datatypes. Either that or the data is unpivoted.

Could you provide a more structured data (maybe use Excel), along with the column names, so that it becomes easier for us to identify the problem?

[Anonymous]

thanks for your time, it was suggested to unpivot the columns.

appreciated your support

[Anonymous]

great help appreciated your help, now fix it for me

regards