Forum Discussion
Date Slider Not Handling Years Correctly
Anonymous do you have sort order on chat to z->a instead of a->z, click on dots on top right corner of the chart and check the sort order.
Regardless of A>Z vs. Z>A, it displays incorrectly.
A>Z it appears as follows:
January 2019
February 2019
March 2019
November 2018
December 2018
Z>A it appears as follows:
December 2018
November 2018
March 2019
February 2019
January 2019
Power BI is not correctly recognizing the year.
Anonymous by default it sorting alphabatically. You need add another column in your table to sort this month field.
Add following column in your date dimenson, change table name and column name as per your model.
Month Sort = FORMAT( Table[Date], "YYYY-MM" )
Now go to modelling tab, choose your month colum and click sort by column on the menu and select "Month Sort". This will fix the issue.
Thanks! This seems to be on the right path. When I try to sort on "Month Sort" I get the error "This column can't be sorted by a column that is already sorted, directly or indirectly, by this column."
Anonymous do you have date dimension in your model? The month column you are trying to sort, are you using the same column to create sort column?