Forum Discussion
Auto Filter Based on Slicer Date
I have a slicer that is limiting a data set to the most recent "as of date" the table has the below structure. I need to further limit the output in my visuals to display only totals with an OpenDate...
HI Anonymous,
You can add a measure to extract the current slicer selection and compare it with the 'open date' field values to return flag, then you can use this measure on the 'visual level filter' to filter records based on the flag.
Applying a measure filter in Power BI - SQLBI
flag = VAR currSelected = MAX ( Table[AsOfDate] ) VAR currOpenDate = MAX ( Table[OpenDate] ) RETURN IF ( currOpenDate <= currSelected, "Y", "N" )Regards,
Xiaoxin Sheng
danextian
Super User
Super UserHi Anonymous ,
Have you tried using another date slicer, this time, for OpenDate?
I did, it works but I would ideally like to default the slicer selection to the month of the 'AsOfDate' if that makes sense?