Forum Discussion
Date Slider For Single Date - Not Range
This is a bit of a hack but...
Step 1. Create a date slicer, then use the dropdown to select "Before" (make sure "Slicer header" is visible), this creates a set of dates that ends at a certain time. You could also select "After" but, in Step 3 below, you'll need to use "Bottom" instead of "Top".
Step 2: Create a measure that selects distinct dates. For example, I defined mine as:
Distinct Dates = DISTINCT([MyDateField])
Step 3: Select the visual that we want to use a specific date on. Create a filter on the date field ([MyDateField] in my example) with the following settings:
"Filter type" = "Top N"
"Show items" = Top 1
"By value" = distinct date measure ("Distinct Dates" in my example)
One issue is the slicer's slider still shows a range of dates ending at your "Before" value but hopefully the users can get used to that. I haven't figured out a way to re-format that.
This solution worked for something I have been working on. Basically, created a date picker thanks to the wonderful Guy in a Cube video and needed to filter the corresponding data in the visuals to only the single value showing. Your solution worked. Thank you!
