relative slicer for timestamp (date and time)

[efhache]

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

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?

[efhache · Accepted solution]

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.

[viz_vignesh]

One cannot view data from 2 different days using the relative time slicer, is it?

For example: If I need to view last 24 hours of data and currently I am able to view only the data from today and not yesterday's data

[amitchandak]

@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