Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

TRICKY Sort in Power Bi Desktop

Hi Experts

 

I need to sort the following values based on Date  Time then value highest to lowest in a Table in Power BI Desktop

 

Need Help

10 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    3 years ago

    Hi Anonymous ，

    Based on your pictures, isn't the current sorting accurate? Please share your data in a way that is easy to replicate and show the output you expect. Remember to delete confidential data.

     

    Best Regards

    Lucien

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      This is what the graph should look like....plotted in Excel

      https://www.dropbox.com/s/uh87n0fc0arnvhg/test_.pbix?dl=0 

       

       

      I want my Power Bi line chart to look like the excel plot. if you look at the power bi line chart and view the data in Power Query, it's not plotting correctly based on the data points (date and time log).

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Community Support
      See image if you add an index column this is the correct order of how the line graph SHOULD plot...(this is fine in power query), but the sort order goes out of sink in desktop.