Forum Discussion
Slicer - Date and Time
Stoo48You know I never switched the Slicer in my testing from List to any of the Before, Between and After Options!
It seems when you place a TIME column in the Slicer you can only use the List or Dropdown Options
I believe the others are only meant to be used with DATES
So there's not really an issue with the Data Type and Format!
>>> The issue seems to be with Slicer's Before, Between and After options not working with TIME Columns! <<<
Checkout this blog by heathernicole dbadmin
She discussed the Advanced Time Slicer
Good Luck! :smileyhappy:
Sorry that's probably not the answer you were we looking for.
You can report this as an ISSUE here
How do you split the original column?
select the original Column
Go to the Add Column tab => Date button => select Date Only
and then again same original column => Time button => Time Only
I hope this resolves it! :smileyhappy:
EDIT: I can't duplicate this but I've had issues with not being able to format dates... (but not with Slicers)
the above has been fixed
this is still not
http://community.powerbi.com/t5/Desktop/Facet-Key-Custom-Visual/td-p/80087
and the Facet Key Custom Visual STILL does NOT work woith dates :smileysad:
I used the split column function in the query editor, will try your method too
Apologies for the delay in feeding back, your suggestion on how to split the columns worked well, however the time slicer still shows up as dates from a century ago..........
Input:
Output:
Any thoughts and suggestions gratefully received...........