Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Icon for Helper V rankHelper V
3 years ago
Solved

Time 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...
Need Help
Show and Tell
Tips and Tricks
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Hi Ibrahim_shaik 

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=-q7v56p192M

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

https://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_shaik's avatar
    Ibrahim_shaik
    Icon for Helper V rankHelper V
    3 years ago

    Hi 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's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      3 years ago

      Glad to help 😊