Forum Discussion
PowerBI Date Fields not Sorting Correctly
Hi,
I'm struggling sorting my graphs in chronological order.
I've setup the Date Table and using the field Date as the Date Column and it's data type is Date.
I'm creating a custom Date Hierarchy afterwards and changing sort field in each graph it won't work.
* I've tried by turning on and off the Automatic Time Intelligence option but it didn't change anything.
Thanks in advance.
Anonymous , If you have column month which you are using in the hierarchy, you need to have sort column.
Or create month column and month sort column. And mark month sort as sort column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")Month = FORMAT([Date],"mmm")
Month sort = FORMAT([Date],"mm")refer
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
2 Replies
Anonymous , If you have column month which you are using in the hierarchy, you need to have sort column.
Or create month column and month sort column. And mark month sort as sort column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")Month = FORMAT([Date],"mmm")
Month sort = FORMAT([Date],"mm")refer
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column