Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

"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?  

1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.