Forum Discussion

mattkocak's avatar
mattkocak
Icon for Kudo Kingpin rankKudo Kingpin
4 years ago
Solved

Slider Slicer that Includes Time (Not just Date)

Hey all,   I have a Time column that I would like to create a slider slicer for, similar to what's available for a Date column.     However, I haven't been able to find a way to do this. I...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    No, that is not possible. Use the filter pane instead.

  • raymcgaw's avatar
    raymcgaw
    3 years ago

    I was able to make a time slicer, but it was indepentent of the date, so you would first have to filter the date and then the time.

     

    In power query, I split the time and minutes from the timedate into text, then converted back into a number (the minutes need to be padded with a zero):


    Number.From(
    Text.From(Time.Hour([Timestamp_Time])) &
    Text.PadStart(Text.From(Time.Minute([Timestamp_Time])), 2, "0" ))

     

    I created a slicer with the number in it (used Greater than or equal to, but Between also works):

     

    To get it to look like time, I formatted the number to 0#:##

     

     

raymcgaw's avatar
raymcgaw
Frequent Visitor
3 years ago

I was able to make a time slicer, but it was indepentent of the date, so you would first have to filter the date and then the time.

 

In power query, I split the time and minutes from the timedate into text, then converted back into a number (the minutes need to be padded with a zero):


Number.From(
Text.From(Time.Hour([Timestamp_Time])) &
Text.PadStart(Text.From(Time.Minute([Timestamp_Time])), 2, "0" ))

 

I created a slicer with the number in it (used Greater than or equal to, but Between also works):

 

To get it to look like time, I formatted the number to 0#:##

 

 

karpagam's avatar
karpagam
Frequent Visitor
2 years ago

can you please elaborate the process in step by step in Power BI ?