Is it possible to have date slicer having last 12 days as selected by default

[SaurabhMahajan]

I have a date slicer which should show last 12 days as selected when report opens. Further, user should have flexibility to select any other date range.

[parry2k]

did you looked at relative date filtering? here is the link which can provide more details about it.

[SaurabhMahajan]

Relative Date filtering gives option to get data of last/next few days. But, simultaneously we want option to get data between any two dates, which is not possible in relative date filtering.

[v-piga-msft]

Hi @SaurabhMahajan,

Have you solved your problem?

If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

As another option, you could create a between slicer for your user to select data range and drag date filed to visual level filter or page level filter. Then you could set the date filter to be last 12 days, it will show the data last 12 days when you open the report.

In addition, you could vote this similar idea in Power BI ideas Forum.

Best Regards,

Cherry

[SaurabhMahajan]

With above approach, we are adding relative page level filter as 12 days. But, user won't be able to see any data prior to this data range.

We are expecting a between date slicer in which last 12 days are shown selected by default. But, user should have flexibility to select any historical date range.

[v-piga-msft]

Hi @SaurabhMahajan,

For your requiement, if you want to show the data of the last 12 days by default and you also want your user could slicer the data out of the last 12 days, it may impossible for us to to that directly in Power BI because there will be conflicts between filters.

For a workaround, I suggest you could use Bookmark features.

You could create Page 1 with a relative slicer (last 12 days )and Page 2 with a date between slicer witch your users could filter the date range.

Then you could set the Page 2 with Bookmark and create a bookmark button in Page 1.

When you open the report it will show the Page 1 with the data last 12 days by default, if you want to slicer other dates, you could click bookmark button to Page 2 and select the date slicer.

Best  Regards,

Cherry

[parry2k]

@v-piga-msftThat is good solution but I'm not able to understand why we cannot use Slicer in this case, that is easy to manage/scalable solution

[parry2k]

@SaurabhMahajandid you tried the slicer option which I mentioned earlier or you think that is not the option.

[parry2k]

may be the option is to add a slicer with two options:

Last 12 days

User selected date range

and in your calculation use date selection based on slicer, if it is last 12 days then calulate the date range and apply in the fomula, also use this as a default selection, so that when user opens the report, it is always 12 month otherwise if use selected 2nd option in selected then use date range.