Forum Discussion

sacheu's avatar
sacheu
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

How can I create a date/time slicer for date AND time.

I have a 'Date/time' column in my Data table in PowerBI. And I want to create a slicer so that i can filter all the widgets in the PowerBI with selected date AND time.

 

I create a slicer widget with that column and use 'between' as the slicer type. This is I only get 'Data' in the slider. How can i get time as well?

 

 

Thank you.

 

 

 

3 Replies

  • sacheu , I power bi I doubt you can have DateTime slicer together. There is relative time slicer separately

  • sacheu's avatar
    sacheu
    Icon for Microsoft Employee rankMicrosoft Employee

    Thanks. Can you please tell me if there is any way for me to filter the results to a specific time range ? say 9:15 am to 11:18 am? Instead of 'Last x minutes'?

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi sacheu 

    At present, the built-in slicer of the system does not support filtering of the Time level. But I found a blog that describes how to customize the time column and then combine it with other slicers. You can refer to it.

    https://community.powerbi.com/t5/Community-Blog/Advanced-Time-Line-Slicer-Sorting-data-by-shifts-up-to-every/ba-p/37006

     

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.