Forum Discussion
Helper IHow to mae dynamic date/time slicer?
Hi
I have date/time column as below
I wanted to make a combined date-time slicer. For example, I want to select 01/01/2021 5 PM or 01/01/2021 4 am. Is that possible in Power BI?
I have gone through a similar kind of posts but not successful
Please advise
Hi Jason2500 ,
Based on your description, if I understand correctly, you may just want to filter out a specific hour value. Is that correct?
You can create a column as follows.
My test table:
Column:
DT-hour = HOUR('test'[DT])&" - "&'test'[DT].[Date]Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- parry2k
Super User
Jason2500 not exactly but you can have relative time, check here more about relative time.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi Jason2500 ,
Based on your description, if I understand correctly, you may just want to filter out a specific hour value. Is that correct?
You can create a column as follows.
My test table:
Column:
DT-hour = HOUR('test'[DT])&" - "&'test'[DT].[Date]Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
