Forum Discussion

darkmetrics's avatar
darkmetrics
Icon for Helper I rankHelper I
3 years ago

How to set default date range in slicer?

Good afternoon!

I have a chart with daily sales data. The date range is 1 January - 15 October 2022.

I have a date slicer for my chart:

I want the slicer to select last 4 weeks by default, so at 15 November the date selection should look like:

 

 

I have found similar question on the forum: link to the question But this question is not exactly what I need because the filter in the solution blocks an option to select date range another than selected by default. For instance, if the total date range of the chart data is 1 January - 15 November 2022 and I make the default date range between 1 October and 15 November in such way as recommended in the solution above than I will not be able to select date range between  1 January - 1 October because of the filter applied to the chart.

 

Thank you in advance!

2 Replies