"Dynamic" Between Date Slicer with both Relative and Default Dates
Using a date slicer we would like for the date to dynamically display the last 30 days of data by default, however also allow for the user to change those dates to pull in more data. The only way we've found to do this is to set both the header and filter to Relative - however when doing this you lose the "Date Format" in the header slicer which becomes a selection list of Last/Next/This 30 Days/Months/Weeks. While this produces the desired data sets and allows for both dynamic and default dates in the slicer, its not end user friendly since they have to figure out how many days or months to go back vs just clicking some dates. Has anyone come up with other ideas to handle this?