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

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?

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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 :)

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        Anonymous beautiful, you are on right track.

         

        Now set the relationship between your new date table and your transaction table. Do month sort in your date table and use month from date table in your visuals.

         

        Assume you don't have date fields in your transaction table (just hide those) and anything related to time intelligence use fields from date table.

         

        Good luck!!