Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Arrange date in correct order

Hi everyone,   I plotted a graph but the date structure is not arranged graphically. I got this column of dates from my excel file and It is in format Jan-16 which means January, 2016. I want to di...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    Please create a custom column in power query:

     

    = Table.AddColumn(#"Changed Type", "Datefororder", each Text.Insert([No. of Working Days],4,"20"))

     

    Then convert it to date in data view:

     

    Then you can use sort by columns:

     

    Please refer to the pbix file.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous a quick check , have you already tried the sort option on the visual ?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    Yes, I already tried it but It is not working.

     

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      So, in the table of PBI, the "Date" column (you got from excel) has been marked as Data Type "Date"?

      If so, you may have to create another table for sort... as other replies introduced.