Forum Discussion
Alejandro
4 years agoRegular Visitor
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
2 Replies
- AlejandroRegular Visitor
Any ideas?
- v-easonf-msftCommunity Support
Hi, Alejandro
Is the screenshot below the result you want? Please uncheck the option 'show item with no data'.
Best Regards,
Community Support Team _ Eason