Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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