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

[sacheu]

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.

[v-yetao1-msft · Accepted solution]

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-...

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.

[sacheu]

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'?

[amitchandak]

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