@stellaj ,
I believe @ankit is correct that this can’t be done with a single slicer. However if you are willing to separate the start and end dates into two slicers, then it is possible with a fair amount of work. Here’s how to do it:
- Create two disconnected Date tables, composed of the Date column from the Dates_DM table
- Use the first disconnected table for the start date slicer
- Harvest the value from that slicer
- Add 14 days to the harvested value to get the max end date
- Use the second disconnected table for the end date slicer
- Please a visual filter on this slicer limiting the date to the max end date calculated in the step above
- Create a final measure limiting the axis of the line chart to the max end date calculated 5-6 above.
Below is a screenshot showing how this works.
I have also attached the PBIX solution file. I hope this is helpful.
- Brian
eDNA Forum - DateSlider Solution.pbix (25.7 KB)