Constrain Date Slicer to Specific Start Date

[irnm8dn]

I have a dataset in which I am using a Date Slicer which I think is a great user feature.

My dataset has more history than I would care to make available and I want to "limit" the slicer to between 1/1/2017 and all future dates.  The column is "Start Date".

I don't seem to be able to constrain the date slicer to a minimum/earliest date.  

When I use the filter capability, it does not seem to have an impact on the slicer limiting the date range options to between a Start Date of 1/1/2017 and forward.

Any solutions out there?

Thanks in advance.

[MFelix]

Hi @irnm8dn,

Do you want to have the rest of the information available for other reports or do you want to filter the information in Pbix file all together?

If it's on the report the option provided by @alanhodgson is the best however if it's for the full dataset probably you can set a parameter in the query editor and used it to filter the data in the column you want. After that if you need to have your data set refresh in a different date you can edit your parameter direcly in the report, check the printscreen below.

 

MFelix

[alanhodgson · Accepted solution]

Hey @irnm8dn,

Have you tried a visual or page level filter on the "Start Date"? See below (I have Hire Date in my dataset):

Hope this helps,

Alan

[irnm8dn]

Thanks Alan.  Just what the doctor ordered!