I have a few clients that are requesting data slicers that default the end date to be the most current date in the data. Currently, I have filters on these slicers using the “Relative” type filter where it gives us the last 6 months of data. These datasets are refreshing multiple times per day so the most current date is always the current date.
When I look at these reports the default end date in the slicer is not defaulting to be the current date. Below is a screen shot of what I am referring too. Also, they would like to use the “between” logic in the slicer and not the “relative” logic so they can pick date ranges and not be stuck to grabbing the last x amount of days or months. Any help or guidance is appreciated, Thanks!