Forum Discussion
Solved
Creating Date Slicer for when values are not blank
Hello, I need the ability to create a date slicer that will only show a range where the values during that time are not NULL. Example Site Date/Time How many Units A 4-5-2022 12...
Hi RaphaelSlalom ,
We generally use Measure as a visual-level filter, but it cannot be used in Slicer.
Measure = var _minBlankDate= MINX(FILTER(ALLSELECTED('Table'),ISBLANK([How many Units])),[Date/Time]) return IF(MAX('Table'[Date/Time])<_minBlankDate,1,0)Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RaphaelSlalom
I think you should not add the filter in dax rather you can try to add the filter on visual level, page level or Report level this will definately work and your measure wont be complex
I would agree with you except I have another filter (relative date, "last 5 days" that seems to be overwriting the "how Many units filter"