Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
4 | |
4 | |
2 | |
1 |
User | Count |
---|---|
15 | |
10 | |
6 | |
5 | |
4 |