Forum Discussion
Default State For Between Date slicers
- Anonymous2 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.
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.
Yes , this would definetly work but in my case I am not restricting date to be in last n numbers hence this would not be useful , also when we open the report this will show last used date rather than pointing the entire report to yesterday