Forum Discussion
Helper VTime Slicer Between Style Shows only Date. NOT TIME
Hi Power BI Community,
I have a table with a DateTime Column I have separated the date and time into two columns and I want to filter the line chart separately with date and with time.
I have used the Between Slicer for Date I want to use the Same Between Slicer for the Time as well but when i Place the Time column in the value field in the Slicer it only shows Date and I get a wierd date 12/30/1899.
Another thing is I want to create a disconnected table of Time with 1 hour interval in 12 hour format AM/PM. and then I should be able to filter the line chart with that Time Table. as I have time 15 interval time data, i want to filter the line chart "Between" two different timestamps. I tried creating the disconnected Time Table but I was not able to filter the line chart.
I have attached the Screenshots of the Slicer and DateTime Table.
Please help.
Thanks & Regards,
Ibrahim
Unfortunately slicer "between" doesn't work with time formats.
You can use different time buckets with numeric / text formats with lists instead 3
Please refer to the linked tutorials:
https://www.youtube.com/watch?v=-q7v56p192Mhttps://community.fabric.microsoft.com/t5/Desktop/Slicer-with-time/td-p/116526
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Unfortunately slicer "between" doesn't work with time formats.
You can use different time buckets with numeric / text formats with lists instead 3
Please refer to the linked tutorials:
https://www.youtube.com/watch?v=-q7v56p192Mhttps://community.fabric.microsoft.com/t5/Desktop/Slicer-with-time/td-p/116526
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ibrahim_shaikHi Ritaf1983 ,
Thank you for letting me know that the between Slicer does not work with time.
I will refer to all the links you have provided.
Thank you so much for the reply.
- Ritaf1983
Glad to help 😊