Relative Date/Time Filter on Power BI Visual

Hi NHTKID ,

Thanks for Waldo35 's solution, one more thing, we should use NOW function instead of TODAY which will return the time 00:00:00.

If you want to use the relative time, here's the solution.

Sample:

1.Create a new table. Don't make relationship between the two tables.

Table 2 = VALUES('Table'[Item])

2.Create a measure.

Check =
IF ( MAX ( 'Table 2'[Item] ) IN VALUES ( 'Table'[Item] ), 1, 0 )

Put Item column from the new table in a visual, and put the measure in the visual filter then set its value to 0. After apply the relative slicer, get the correct result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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