I have the table that looks like below.out of 5, I should see only 3 as part of the last 12 hours (let's say its 9:07 CST AM now )I'm planning to use it as a filter to show only the last 12 hours entries based on the current(now) time. so A B C will only show on the table/matrix. Need help TicketCreatedDateTimeStatusA5/6/2021 8:47NewB5/6/2021 0:38NewC5/6/2021 0:34NewD5/5/2021 3:37NewE5/5/2021 0:04New

Hi, v_mark IF you want to work for the last 3 or 6 hours, You can change the number of Measure， if it's 3 hours, it's 3/24, if it's 6 hours, it's 6/24. as follows: Flag = IF(MAX([CreatedDateTime])<=NOW()&&MAX([CreatedDateTime])>=NOW()-3/24,1,0) Best Regards,Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

last 12 hours only | Microsoft Fabric Community

7 Replies

dkaushik
Resolver II
5 years ago
Hi v_mark ,

You can try using "Relative time" option on your date slicer.
After that select "Last" and enter 12 and then select "Hours".

This will filter your data in the table visual. Also, if you don't want to use the slicer, you can use the same concept by dragging your "Date" field to Page Filters or Visual Filters and then select Relative Time from the options.

Please mark it as solution and give kudos if it helps you.

Thanks,
Dheeraj
- v_mark
  Helper V
  5 years ago
  My issue right there is it follows are completely different timezone. I'm in CST, I was hoping to see a time 12 hours from my time. Let's say currently it's 10:53AM I should see something like
  
  10:53AM - 10:53PM
dkaushik
Resolver II
5 years ago
Can you share a screen capture of what it looks like when you apply this filter? Also, check what it looks in pbi service when you publish it. If its showing different like mentioned in this post
Solved: Date calculating differently on desktop and web du... - Microsoft Power BI Community

then you will need to convert it to specific timezone first (CST in your case) and then apply a filter on it.

Regards,
Dheeraj
- v_mark
  Helper V
  5 years ago
  Here's what it looks like in the pbi service. My current time is 11:12 AM
v-yalanwu-msft
Community Support
5 years ago
Hi v_mark ,

You could create a measure by the following formula:

Flag = IF(MAX([CreatedDateTime])<=NOW()&&MAX([CreatedDateTime])>=NOW()-0.5,1,0)

Then apply Flag measure to Filter:

If you only want to see the top 3 records within 12 hours, you can add another filter：

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
last 12 hours only.pbix46 KB
- v_mark
  Helper V
  5 years ago
  Will the same approach works for the last 3 or 6 hrs?
  - v-yalanwu-msft
    Community Support
    5 years ago
    Hi, v_mark
    
    IF you want to work for the last 3 or 6 hours, You can change the number of Measure， if it's 3 hours, it's 3/24, if it's 6 hours, it's 6/24. as follows:
    
    Flag = IF(MAX([CreatedDateTime])<=NOW()&&MAX([CreatedDateTime])>=NOW()-3/24,1,0)
    
    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.