Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Between Date Slicer Including dates not in filter

I have created a measure that i'm using as a filter on slicers to prevent users from selecting dates that aren't in the time range they've selected in another slicer, e.g. if they choose all sales before October the slicer wont include products that went on sale after that date. 

 

This has been done through a dax expression as I have pre-existing relationships that prevent me from using a common date table. 

The filter is built using the following code.  

PerfDateFilter = (IF(MAX('TDate Filter'[TDateEnd])> MAX(Artifax_PerfCodes[PerformanceDate]) && Not ISBLANK(MAX(Artifax_PerfCodes[PerformanceDate]))  ,1,0))
 
When I use a dropdown date slicer it works as expected preventing users from selecting October or November
 

However, when I switch the filter to between dates, it includes sales to the end of the year. Enabling users to select dates that haven't been on sale yet. 

 

  • Hello Anonymous , Please select second slicer and on Edit Interactions under Format Tab then choose Filter in the interaction instead of None. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

2 Replies

  • Hello Anonymous , Please select second slicer and on Edit Interactions under Format Tab then choose Filter in the interaction instead of None. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!