Forum Discussion
How to make remove clock time from Timestamp Slicer
Hi Anonymous,
Create a new column using the following formula, then change the data type of the new column to Date under Modeling ribbon and create a slicer using the new column. There is an example for your reference.
DateValue = DATE(YEAR(Table3[Timestamp]),MONTH(Table3[Timestamp]),DAY(Table3[Timestamp]))
Thanks,
Lydia Zhang
So I would need slicer, which have 3 values, "15/12/2016, 14/12/2016, 13/12/2016". Now I would see 6 values.
OutTable
PartitionKey, Customer, Timestamp
1234567890, Nissan, 15/12/2016 9:19.00
1234567890, Nissan, 15/12/2016 9:18.00
1234567890, Nissan, 15/12/2016 9:17.00
1234567890, Nissan, 14/12/2016 8:18.36
1234567890, Nissan, 13/12/2016 4:18.36
1234567890, Toyota, 13/12/2016 3:18.36
Hi Anonymous,
Create a new column using the following formula, then change the data type of the new column to Date under Modeling ribbon and create a slicer using the new column. There is an example for your reference.
DateValue = DATE(YEAR(Table3[Timestamp]),MONTH(Table3[Timestamp]),DAY(Table3[Timestamp]))
Thanks,
Lydia Zhang
Date slicer looks visually good, but behaves very strange way. When selecting all Dates it shows correctly total number of rows and do the graphs very fine.
However when selecting certain date, it should only fraction of rows which means that most of data is filtered out. It behaves like date slicer slices with date with certain clock time. It should show all data from selected date.
Hi Anonymous,
Since this thread has been closed and you have a different issue, please open another new thread to describe your problems with sample data and expected data.
Thanks,
Lydia Zhang