Filter Slicer by another slicer value

[Ben81]

Hi all, 

Hoping this is a simple one as it feels like it should be but I just can't seem to get it working. 

I have a slicer called 'Future Year' that has a year field, I have second slicer called "Historic Year" that uses the same year field. 

What I want is when you select a year on the "Future Year" then the "Historic Year" slicer only shows years before the selected year in the "Future Year"...if that makes sense 🙂

I've tried a few methods but nothing has worked yet.

Ben

[amitchandak]

@Ben81 , Both slicers should be on different tables.

Create this measure and use that visual level filter of historical slicer

new measure =

var _max = selectedvalue(future[year])

return

countrows(filter(history, history[year] < _max))

check this not blank

same discussed here for months

Month Range Slicer: https://youtu.be/nEt7dT3Tfv4

[Ben81]

Okay that makes sense but still doesn't quite work, have I missed a step..

Created a historic table with a list of distinct years. I created a relationship to the main table by years in both directions. 
I created the measure as above.
I created two slicers looking at the two tables and on the historic slicer I added the new measure to the filter pane with 'is not blank' but this just leaves the slicer with no values no matter what I select.

What am I doing wrong?