Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter for Year Showing Three-Digit Values - Please Help

Hi All - 

 

I am running into an issue in which a filter for one of my dataset's features, "Purchase Date", is appearing as three-digit values (e.g., 334) when used as a list filter. The issue does not appear for the other date feature in my dataset, "Creation Date".

 

 

I prepared my dataset using Pandas and have confirmed the data types of both date fields - "Purchase Date" and "Creation Date" - are correct prior to exporting to csv. No null values existed for either field as confirmed by pd.info( ).

 

 

Furthermore, I've confirmed all possible values for the field, "Purchase Date", fall between 2012 and 2015 in my Jupyter notebook. Note, I'm using the the method i.year of the Python module datetime to access the year value for each cell in the series to validate no years fall out of the expected range.

 

 

Finally, I've confirmed both fields are stored as the correct data type in Power BI.

 

 

Does anyone have an idea on what may be wrong here? Appreciate any guidance you can provide.

 

Thanks!

 

4 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, Anonymous ;

    This is very strange, can you share the formula about the year column along with the screenshot? Or you can share the file after deleting sensitive information. It's all normal from the screenshot you provided.

    How to upload PBI in Community


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Yalan - Please see the link I provided above. Thanks!

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, Anonymous ;

    When we load again could find here is an error :

    You can check it out and remove the error.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.