Limit the Date slicer selection

[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