Create From To filters based on MMM-YYYY with condition

[AmiraBedh]

I want to create the following filters :

I want when I select a date from To I want that the selection From is bigger than the first.

How can I achieve that ?

[amirabedhiafi · Accepted solution]

The simplest way is to create an error message when you select the To less than the From : 

FromToValue = IF( SELECTEDVALUE('yourTable'[FromDate]) > SELECTEDVALUE('yourTable'[ToDate])

                             ,"Invalid selection", "")

If you want the hard way : 

FromToValue = IF(CALCULATE('yourTable'[ToDate])>=SELECTEDVALUE('yourTable'[FromDate]) ),1,0)

Set the visual slicer:

since the measure could not be applied it in the slicer,you need to use the measure in visual.