Report Order Dates Not Appearing In Order

[carlton7372]

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?

[carlton7372]

Hi Community,

Can you let me know how to attched PBIX to this chat?

[Anonymous · Accepted solution]

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.

[carlton7372]

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

[Ashish_Mathur]

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.

[carlton7372]

Can you let me know how to attach a file?

[Ashish_Mathur]

You cannot.  Upload the file to Google Drive/One Drive and share the download link of the file.

[carlton7372]

Hi Ashish,

Here is the link

https://drive.google.com/file/d/1kFPBc381gst7TLKXcACBkgBDqy1j6ACq/view?usp=sharing

[Ashish_Mathur]

Please read the reply which i sent you 11 hours ago.  In the absense of a Year column, i canno help.

[Ahmedx]

refer to the following

https://www.youtube.com/watch?v=NlX7Cp2P0d4&ab_channel=GuyinaCube

https://www.youtube.com/watch?v=KUcLScKYg9I&ab_channel=PragmaticWorks