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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors
Top Kudoed Authors