Forum Discussion
Date Slider Not Handling Years Correctly
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."
Super UserAnonymous 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?
I have multiple "Milestone" columns for various completions, but no specfic date column (I'm pulling all of my data from an API).
I changed the "Month Sort" column to be based off of another milestone than the column I'm trying to sort and now get this error:
"We can't sort the "Sorting Column" by 'Month Sort'. There can't be more than one value in 'Month Sort' for the same value in "Sorting Coumn". Please choose a different column for sorting or update the data in 'Month Sort'.- parry2k
Anonymous I know what this error message is, having said that I would highly recommend to add date/calendar dimension in your model and use that to do anything related to time intelligence.
There are many topics on how to add date/calendar table in your model, you can use power query or dax to create the table. It is easier way to work on dates and also it is best practice.
parry2kThanks! I created a date table following this set of instructions.
From here, what is the best practice/ what do you recommend?
Should I still create a "Month Sort" column based off of my new date column?Shouhld I just manage the relationships and then use the date column from the new date table in my visuals?
Just want to make sure I'm setting everything up in the best way :)