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 chart or clustered column chart showing the demand per week. X axis the dates or weeks and Y axis the demand.

 

10/30/201811/6/201811/13/201811/20/2018
9404060
288510.02976144.0004468.17752
18841260
4016024120
1231569
103243139229

 

I have problems to modelling this graphic.

thanks for your help

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

4 Replies

  • 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

      great help appreciated your help, now fix it for me

       

      regards

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

       

      appreciated your support

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    Select all columns and unpivot.

     

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

     

    Best regards,

    Yuliana Gu