Months in graph not listing in chronological order - please help

[delgadomk]

Hi,

I am having a bit of trouble with the way my months are populating in my graph.  I need them to populate from oldest to newest for example: Jan-16, Feb-16, Mar-16, etc., and they aren't doing that, even when I select the sort by month option.  I  have attached a pic of how my appointment months are generated in my query plus a snapshot of how the graph looks.  The way the appointment month populates is directly from the source so I have nothing to do with that formatting.

Appointment MonthsGraphs

Any guidance would be greatly appreciated!

Thanks!

[v-ljerr-msft]

Hi @delgadomk,

Have you tried the solution provided by Vvelarde above? It should work in your scenario. If you still have any question, feel free to post it here.

Regards

[delgadomk]

I still can't get the months to list chronological....

 

And my Sort by Column is not clickable..

This is what my query looks like...

[Vvelarde]

@delgadomk

This look like your problem

https://community.powerbi.com/t5/Desktop/Add-a-serial-number-to-a-new-table-created-in-Power-BI/m-p/...

[ibarrau]

You should change type of the column to Date in power query. Then apply changes. This will allow you to drilldown and up to play and get what you are looking for.

(When adding the column to visualization you can click on the "X" on Trim to close it and keep year/month/day)

Regards,

[Vvelarde]

@delgadomk

Hi, you should Use Sort by Column (In Modeling Menu)

Look this video, is not exactly like you should do:

https://www.youtube.com/watch?v=swJwaWIvVGg

Let me know if you need more help