Forum Discussion

carlton7372's avatar
carlton7372
Helper III
2 years ago
Solved

Report Order Dates Not Appearing In Order

I have imported a .csv into Power BI Desktop. The .csv looks like the following:   My measure looks like the following:       However, the dates on the report are all over the place...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, carlton7372 

    You can get the effect of the month from small to large by adjusting the sorting method of the month. I used the data provided by your picture:

    The result is as follows:

    I hope the above adjustment can help you.

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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

     

     

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Why is there no Year column in the csv table?  Ideally there should be a Date column but if there isn't one, then with a Month column (which you already have) and the Year column, we can create a Date column.  This in turn will allow us to create a Calendar Table.  Ultimately, the Calendar Table will reolve your problem.  So share the download link of the PBI file with either a proper Date column or 2 columns - year and Month.