Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Year Filter

I have a date/time field in my data that has been formatted with the data type of Date/Time. 

In the data when I got to put a filter pane on the report, it shows 2019 twice..

 

Is there any reason why it would do this? Or how to get rid of it?

  • Hi Anonymous ,

    This problem occurs because it puts the Date Hierarchy to the slicer field automatically, we can change it to the original column like below: 

    The result will like below: 

    Best Regards,

    Teige

1 Reply

  • TeigeGao's avatar
    TeigeGao
    Solution Sage

    Hi Anonymous ,

    This problem occurs because it puts the Date Hierarchy to the slicer field automatically, we can change it to the original column like below: 

    The result will like below: 

    Best Regards,

    Teige