Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Issues with dates in Columns

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 char...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Select all columns and unpivot.

     

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

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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

 

appreciated your support