Forum Discussion

Alejandro's avatar
Alejandro
Regular Visitor
4 years ago

Filtered Calendar Slicer Not Working

Hello,

 

I have two calendar dates one fore general filters  (by slicer) and another one to select a previous coparation period. I want that the general slicer filters the comparator slicer doing that min date (minus one day) on general slicer would be max date on comparator slicer.

 

Something like this:

 

So I created a Measure that indicates that and I filtered the comparator slicer with that measure:

 

ShowDate =
var  MinSelected = MIN('Calendar'[Date])
var MaxCompare = MAX('Calendar_Comparations'[Date])
return
IF(MinSelected > MaxCompare , 1 , 0)

 

All is working fine until on the comparator slicer I select as max date the min date (minus one day)  of the general one, the filter is not working well:
 
here is working well

 

Not here (when the max date posible is selected)

Why is this happening, what I am doing wrong?
 
Thanks