I would like to constrain a filter or slicer to values represented in the related facts. For example, if I only have sales for the current year, I would only want the date slicer to show this years date. As it is, the drop down shows all dates from 1900 to 2100. Is there a way to constrain that?
- Pete
- Pete