Forum Discussion
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 as how in the following screenshot:
Can someone tell me why the dates aren't in order?
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.
9 Replies
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.
Can you let me know how to attach a file?
You cannot. Upload the file to Google Drive/One Drive and share the download link of the file.
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.
Hi jianpeng,
Thanks for reaching out. I notice that even you're dates aren't in order after Mar. Why is that?
Ashish, thank you too for reaching out.
I have attached the pbix
Hi Community,
Can you let me know how to attched PBIX to this chat?
