cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Normeister Frequent Visitor
Frequent Visitor

Re: Time of day slicer

I am also struggling with this feature.  Is there a solution out there?  all I want to do is use a slicer between two dates with a specific time.  ex. 1-jul-2018 6:30am to 18-jul-2018 6:30am.

 

Is there a solution to this?

deepakbi Frequent Visitor
Frequent Visitor

Re: Time of day slicer

I am also struggling with this issue. When I put a slicer on datetime feild it only picks date and ignore time. I want filtering on Time as well. Any idea will be appreciated. Thanks..

urnaim Visitor
Visitor

Re: Time of day slicer

I am also struggling with that issue - has anyone found a solution yet? there has to be a way!

 

Thanks in advance!

chrisbarron Visitor
Visitor

Re: Time of day slicer

I would also like to see the ability to slice by time as well as date. I have large date/time stamped data tables which build over 24 hours every day. I need to be able to slice it between 1700 on one day and 1700 on a subsequent day [other random times are also required] and a slider would be the most obviously user-friendly way of accomplishing this. The same goes for Filters, which can't deal with times at all other than manually selecting the required minutes in a Basic filter, which is not practicable for a 15hour sample.

 

I have built a crude slicer value using

slicervalue = hour([datetime])&format(minute([datetime]),"00") formatted as whole number

 

This gives a value between 0 and 2359 for all times, which will then act as a sliding slicer, but it still won't work over different dates.

If the Date slider variant of slicer can convert date values into a slider, then surely it can't be beyond the wit of man to do the same with the decimal time values? Not all of us are looking at data over fanancial years. Some of us are working the fine details.

 

Come on Microsoft. Make us happy.

Highlighted
DesaiH Frequent Visitor
Frequent Visitor

Re: Time of day slicer

did anyone find the solution for this slicer issue?

I also have date and time column seperatly. Based on date selection i want to select my time range but when i have slicer for time, it convert into date 12/30/1899. 

any work around?

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 391 members 3,406 guests
Please welcome our newest community members: