Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date Slider Not Handling Years Correctly

I'm making a report where every visual is filtered by a date slider at the top of the page. It used to function properly, but now it will disregard the year and order the months in chronological ord...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

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.