Creating a 1-1 relationship between fact table and date table

[Euler59]

My fact "sales" table contains transactions between 01/01/2011 and 06/30/2014. My date table contains consecutive dates from year 1998 to 2017. When I use year column from date table in a slicer all the year numbers prior to 2011 and after 2014 are displayed "greyed out" on the slicer. I will like to have only the years containing transactions displayed.
If I can create a 1-1 relationship (aka inner join) between the fact table and the date table, then my problem is resolved. But, how?

Thanks for any assistance,
Robert M.

 

[erinward11]

right click on the slicer and go to Slice Settings...click on hide items no data. This will get rid of all of the years without data.

 

[scottsen]

erin had the correct answer.

I will just add that... for performance reasons, you should really trim that calendar table to just a range of data you actually care about.