Forum Discussion

rahul_verma77's avatar
rahul_verma77
Frequent Visitor
2 years ago
Solved

Default State For Between Date slicers

Hi All,   I got a new requirement where-in when ever I open my POWER BI report in the service, the date slicer should be in today i.e both start Date and end Date should point only to today. Right...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, rahul_verma77 

     

    In addition to IBendlin's approach, you might also take advantage of the Relative Date Slicer feature in Power BI, which dynamically adjusts to always include the day's data.

     

    In Power BI Desktop, create a slicer visual in your report and select a date field for the Field value.
    Select the slicer, and then in the Format pane, under Visual > Slicer Settings >Options, change the Style to Relative Date.

     


    Configure the slicer to display "This" and select "Days" as the date measure. This setting will ensure that the slicer defaults to today's date and updates dynamically every day.


    For more detailed instructions on setting up a relative date slicer, please refer to the official documentation:

     

    Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

     

    The relative date slicer is automatically updated to include only the data for the current day, ensuring that the solution is dynamic. This means that every time you open or refresh a report in the Power BI service, the slicer will default to today's date without any manual intervention.

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.