Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 months ago
Solved

Last 45 days (auto updates daily)

GOAL Default view → Last 45 days (auto updates daily),Power BI to automatically filter to last 45 days from today when the report opens, User can still change date range manually via date slice...
Need Help
  • BITomS's avatar
    BITomS
    11 months ago

    Hi Anonymous ,

     

    If you change your date slicer to a 'relative date' slicer by going to the Format pane > Slicer Settings > Options (see below), you can set the default relative date to Last 45 Days. Once published, this will be your default view that will continue to update based on 'today'.

     

    The user can still update this, or you can add a second date slicer with more specific date ranges if still needed. I don't quite understand when you say: No “Default” / “Custom” button or slicer needed, but you could always hide the relative date slicer if you don't want a user interacting with it.

     

    Hope this helps.

     

     

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
11 months ago

Thankyou, BITomS for your response.

Hi M_brahmareddy,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solution provided by BITomS to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.