Limit the Date slicer selection

[stellaj]

Hi all,
Can you please share your thoughts in getting this sorted?

I have a Date slicer with 4 weeks of rolling data.
The requirement is to allow user to select only 14 days or less.
The user should not select more than 14 days on the date slicer.

I have attached the sample file.
DateSlider.pbix (19.1 KB)

Regards,
Stella

[EnterpriseDNA]

Bumping this post for more visibility.

[ankit]

Hi @stellaj - The requirement is not feasible inside Power BI. One can only limit dates by applying Visual/Page/Report level filters but it is not possible to restrict users to select only 14 days or less.

Thanks
Ankit J

[BrianJ]

@stellaj ,

I believe I have solved this issue in the thread below. Please refer to that for the suggested methodology and solution file.

PBI limit date period selection

@stellaj , I believe @ankit is correct that this can’t be done with a single slicer. However if you are willing to separate the start and end dates into two slicers, then it is possible with a fair amount of work. Here’s how to do it: Create two disconnected Date tables, composed of the Date column from the Dates_DM table Use the first disconnected table for the start date slicer Harvest the value from that slicer Add 14 days to the harvested value to get the max end date Use the second disc…

Thanks.

• Brian