cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
efhache
Regular Visitor

relative slicer for timestamp (date and time)

I have a table with a timestamp field as shown below.

efhache_0-1614860213536.png

 

I would like to create a 'slicer' to display only the data based on a relative timestamp:
all the entries for which the 'start' column is between day D 6h00 and day D+1 05h59 (i.e. a total of 24 hours).

I can make a slicer on date or time independently but I can't find how to really have the desired range of 24h.

Someone can explain me how to do?   Wouldn't there be other solutions than to create a column with a -6h time switch to use a D and D+1 filter?

1 ACCEPTED SOLUTION
efhache
Regular Visitor

ok, so the workaround is a substract 6h to do a switch  and then filter on date. Not really happy with this approach but it finally works.

View solution in original post

2 REPLIES 2
efhache
Regular Visitor

ok, so the workaround is a substract 6h to do a switch  and then filter on date. Not really happy with this approach but it finally works.

View solution in original post

amitchandak
Super User IV
Super User IV

@efhache , In power bi You have a relative date slicer and relative time slicer, not both together

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

https://docs.microsoft.com/en-us/power-bi/create-reports/slicer-filter-relative-time



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors