Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Hi @Anonymous,
When the user view the report, it's not able to change slicer mode, it keeps displaying as a relative mode slicer if you save the report with this state. If you want the user can filter data view relative date filter and desired date value check based on their needs, you can drag the date column field to filter pane, see: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range#using-the-relative-date-range-filter
Best Regards,
Qiuyun Yu
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.