Dates in chronological order

[Ottmar_W]

HI,

I have some difficulties with ordening my dates in chronologic order when i'm making a line graph.

How can that be solved?

Thanks in advance

[ccakjcrx]

@Ottmar_W

Hey!

@jthomsonis probably on the right track. You have to go to the model, add a new column (we'll call that column B), and then sort your date column by 'column B.' 

There are several thread in the PBI community concerning this issue. Here is a URL that has really good screenshots illustrating what is probably the solution to your problem:

https://blogs.msdn.microsoft.com/samlester/2017/04/02/sorting-by-month-names-in-power-bi/

[Ottmar_W]

Hey, @ccakjcrx

Can I sent you my file so you can solve it for me? 

Because I really don't have a clue how this tool work.

Thanks in advance

[ccakjcrx]

Hey!

Absolutely. Send to ccakjcrx@gmail.com.

I’ll be away from my PC from a while. I can get to it in a few hours.

[Ottmar_W]

Hi,

@ccakjcrx

Can it be that your emailadress isn't right, because I can't sent it to you.

My outlook gives me an error message.

Thanks in advance

[ccakjcrx]

@Ottmar_W

Hey!

That is definately my email address.

[Ottmar_W]

Hi, @ccakjcrx,

Maybe you can sent first an email to me than can I answer on that.

ottmar.willemyn@student.howest.be

[jthomson]

Can you elaborate? if it's a "months sorting alphabetically" thing then add an index column and have your month name column sort on that, but you're not giving us much to go off

[Ottmar_W]

Hi,

I will show you an exemple of what i'm making. 

I really can't order them chronological so what can I do about that?

Thanks

[jthomson]

Can you check if your date field is actually formatted as a date?

[Ottmar_W]

How can I check this? 

[edejes2]

Hello Ottmar_W,

Here you go.

Regards'

ED 

[Ottmar_W]

@edejes2

Hi, 

Is there a possibility that I sent you my file?

thanks in advance

[edejes2]

Hello @Ottmar_W

Is this what you are trying to achieve. Also, you want to do some cleaning on your tables as well as renaming them based on the data they hold.

[Ottmar_W]

@edejes2

Yes, my biggest problem is that the dates are not in the correct order. Like you outlined in red.
Thanks

[Ottmar_W]

Hi,

Can someone place my months in chronological order for me?

Because I really don't know how to do it myself.

Thanks in advance

[v-jiascu-msft]

Hi All,

Please pay attention to your privacy.

Hi @Ottmar_W,

If you can make your file public, you can upload it to a cloud drive like OneDrive, GoogleDrive and share the link here. Or you can send me a private message.

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @Ottmar_W,

You need an auxiliary column in your scenario. 

1. Add an index in the Query Editor.

2. In the data view, Sort by Column the index.

Best Regards,

Dale

[Ottmar_W]

Hi,

@v-jiascu-msft

Is there a possibility that you can do it for me?

Thanks in avance

[v-jiascu-msft]

Hi @Ottmar_W,

I have sent you a private message. Did you receive it?

Best Regards,

Dale

[v-jiascu-msft]

Hi @Ottmar_W,

There is a sort option in the top right ellipses. Click the icon in the head when it's highlighted. 

Please pay attention to your privacy.

Best Regards,

Dale