Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Any guidance would be greatly appreciated!
Thanks!
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
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...
This look like your problem
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,
Happy to help!
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