Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |