How do I create a slicer that slices by hours/minutes?

[HamidBee]

I am trying to create a slicer that slicers by hours/minutes. I have data column in dd/mm/yyyy hh:mm:ss format. Does anyone have any idea how I could do this?.

Thanks, 

[mahoneypat · Accepted solution]

Best practice is to split your DateTime columns into Date and Time columns, and then add Date and Time tables to your model.  Please see this article and embedded videos.

Calculate and Format Durations in DAX – Hoosier BI

Time Tables in Power BI – Hoosier BI

Pat

[HamidBee]

Thanks for the advice. I'll try follow the articles.