Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Slicer

I create a slicer from test date.

When I try to use slicer as a date filter, I got the wrong calculation. After adjust slicer, all % = 100%

However, if I change date to hiearachy. The data is correct again.

 

 

why I got the wrong answer when I try to use date slicer (and set the date as actual date-time)

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I think I found the solution.

     

    The original test_date is a date -time format.

    After I create another column with date format only and use it for slicer, it works correctly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I think I found the solution.

     

    The original test_date is a date -time format.

    After I create another column with date format only and use it for slicer, it works correctly.