Forum Discussion
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...
parry2kApologies! I am getting some funky results -- this is probably intuitive for most, but just to clarify, here's what I did:
-The "Month Sort" column is in the transaction table and it is based on my "Milestone Date" column from the transaction table
-I linked the transaction table and date table in relationships. I connected the "Milestone Date" in my transaction table to my "Date" column in the date table.
-On my slicer for my visual, I put the "Date" column from my date table into the field.
Please let me know where I went wrong and what do differently. My end goal is to have a slider that correctly filters all of my visuals by the "Milestone Date".
Thank you for your patience!
