Power BI: Slicer for last 24 hours and 7 days

Question

I have gone through various forms,and I failed to get a solution,I am trying to create a slicer which shows past 24 hours and 7 days 

I have tried but I got a timestamp which shows 

DD:MM:YYY HH:MM:SS PM/AM

So I have tried the following measures

minTime = 
var temp= NOW()
return
if(HOUR(temp)>=8,temp,DATE(YEAR(temp),MONTH(temp),DAY(temp)-1)+TIME(8,MINUTE(temp),SECOND(temp)))

 and Table Column

New Table= FILTER(ALL(TABLE),[Date]>=[minTime]&&[Date]<=Now())

Which gives me an error

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. 

How can I solve this? 

Answer 1

1. Use a table as Slicer

 

 

2. Use this measure as visual filter

 

Last24Hour = IF(SELECTEDVALUE('Show Last 24  Hours'[Show Last 24 Hours],FALSE()),IF(DATEDIFF(SELECTEDVALUE('Table'[Time]),NOW(),HOUR)<=24  && SELECTEDVALUE('Table'[Time]) <= NOW(),1,-1),1)

 

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification