Forum Discussion
Date Slider Not Handling Years Correctly
Super UserAnonymous 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!!
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!