Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

How to make remove clock time from Timestamp Slicer

I have Timestamp in format of 13/12/2016 09:00:00. Timestamp in this format is needed for charts.

When I create list slicer with timestamp I get list in 13/12/2016 09:00:00 format.

What needs to be done so that list slicer is format in 13/12/2016 without clock time.

Anonymous
9 years ago
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

9 Replies

Anonymous
Not applicable
9 years ago
Hi Anonymous,

You can 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.

DateColumn = TableName[Timestampcolumn]

Thanks,
Lydia Zhang
- Anonymous
  Not applicable
  9 years ago
  Thanks. I got slicer with format "13/12/2016". However this method just removed clock time this I got like 1000 of "13/12/2016" in slicer ist as there are 1000 rows on that day. How to make unique date slicer so that each date apper only once in the slicer list?
  - Anonymous
    Not applicable
    9 years ago
    Hi Anonymous,
    
    You can create a new table using the following similar formula, change the data type of TimeStamp column in this new table to Date, then create a relationship between your table and the new table using TimeStamp column. In this way, drag TimeStamp column of your new table to slicer.
    
    Table = DISTINCT(testsclier[DateKey])
    
    Thanks,
    Lydia Zhang

Related content