Forum Discussion

Anonymous's avatar
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...
Need Help
  • Anonymous's avatar
    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I create new table "DimDate = DISTINCT(myTable[Timestamp])"

I created relationship between DimDate and myTable with Many To One + Both.

 

I added slicer based on DimDate table and changed datatype as Date.

 

I still see multiple dates from same date thus date values are not distinct.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

Please help to post sample data of your TimeStamp column with which I can test in my Desktop.

Thanks,
Lydia Zhang

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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.