Forum Discussion
Slider Slicer that Includes Time (Not just Date)
- 4 years ago
No, that is not possible. Use the filter pane instead.
- 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#:##
Hi raymcgaw, thanks for the sweet solution, but how did you format the slicer? In powerBi I can't find the settings you posted for formatting the new number.
Select the field in the data pane and then go to Column Tools, the format option will be in the main ribbon: