Forum Discussion
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-msftCommunity 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.- AnonymousNot applicable
Hi Yalan - Please see the link I provided above. Thanks!
- AnonymousNot applicable
Thanks for the response. Here is a link to the folder: https://drive.google.com/drive/folders/1EgAdrmI6IAjhfWlgt8S_e7I3zyA8Zihr?usp=share_link. It contains the PowerBI file and original CSV file.
One thing, I viewed the full dates in the slicer for "Purchase Date", two strange dates appeared at the top. Neither of these are present in the CSV file to my knowledge. Could these be causing the issue?
- v-yalanwu-msftCommunity 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.