Dates Appearing Out of Order in the Visual

[MExtross]

Hello!

I am trying to make a chart which details the totals on a monthly basis from 2013 to 2017 starting with July and ending in June. The data is in the right order however when I select the line graph, it switches up the order of the months, as seen below. When I select "Sort by Month" in the top right corner, the order changes, but it is still not the order that I originally wanted or the order that the data is in.

Please let me know if there is a way to fix this.

Thank you!

[Anonymous · Accepted solution]

I belive this has been answered before:

https://community.powerbi.com/t5/Desktop/Sorting-by-Month-as-Text-Jan-Feb-Mar-etc/m-p/9242#M1729

In the model you can have a column sorted by another column. Take a look at the link.

Hopefully this gets you what you need.

[MExtross]

@Anonymous,

Wow such an easy fix! Just had to create another column and the select sort by number.

Thank you for your help!