Forum Discussion

Frequent Visitor

6 years ago

Solved

Sort Months by dates in date table

Hi, I have my date table sorted by date and in visual my month are not sorted by by the date but by months alphabetically. I have marked my table as date table too. My date table: ...

Need Help

amitchandak
6 years ago
The sort column did not save correctly. I did it and it is working.
https://www.dropbox.com/s/ikvk0k3juemuqj9/SortMonthQ.pbix?dl=0

amitchandak

Super User

6 years ago

Sometimes the visual by default sort it on Value. Have you checked it is sorted on the month column?

If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

kap_55

Frequent Visitor

6 years ago

I added link to my dummy file where I wanted to just create calendar table and I did exactly the steps from my original file and it still doesn't work, so you can check it.

amitchandak
Super User
6 years ago
The sort column did not save correctly. I did it and it is working.
https://www.dropbox.com/s/ikvk0k3juemuqj9/SortMonthQ.pbix?dl=0

Forum Discussion

Sort Months by dates in date table

Related content

Date Table - Years and Months Only

Performance issues with Date Table + Duplicate Date Table setup (Last 13 Months + complex measure)

DAX Table Sorting Months

Date Slicer not Responsive to Calculated Date Table

DAX Month Date Table