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
Community ChampionCheck in the Modeling Tab (not in the Query Editor since you've already set it there)
What is the DATA TYPE and FORMAT set in the Modeling tab?
Sean
Just checked, as the Query Editor, they are both showing correct TYPE and FORMAT in the modelling tab as I described above
- Sean
When you Import that column in the Query Editor (the original Date/Time column before you split it)
Does it default to Date/Time or Text?
Inside the column are the numbers left justified or right justified when you first import it?
And same for the 2 columns that you split the original into
Do they default to their appropriate Data Type in the Query Editor?
OR
Do you have to manually set the Data Types?
EDIT: Are you running the latest release?
https://www.microsoft.com/en-us/download/details.aspx?id=45331
Columns, post split above^^^
Columns, pre split below
Regarding latest version, I am 1 release behind.........
