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 ...
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
Hi Amit, thank you for the support. The issue is solved.
It seems PBI needs basically requires a sorted numeric field of the correspending date (formatted as text e.q monthname, weeknumber etc) column.