Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Incorrect display of date after implementing the code in query editor

I'm fairly new to Power BI, and I'm encountering an issue with the display of the "Action Date/Time" column in my Power BI report and seeking any helpful suggestions on how to resolve it.   Please ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Ensure that the "Action Date/Time" column in your Power BI model is set to the correct data type. Power BI should recognize it as a data type.

    Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn

     

    If you've applied transformations in the Query Editor, ensure there's no data type mismatch that could be causing the issue. Sometimes, date and time columns imported as strings can lead to incorrect interpretations.

    Best practices to optimize Q&A - Power BI | Microsoft Learn

     

    Best Regards
    Community Support Team _ Rongtie

    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
2 years ago

Hi Anonymous ,

Ensure that the "Action Date/Time" column in your Power BI model is set to the correct data type. Power BI should recognize it as a data type.

Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn

 

If you've applied transformations in the Query Editor, ensure there's no data type mismatch that could be causing the issue. Sometimes, date and time columns imported as strings can lead to incorrect interpretations.

Best practices to optimize Q&A - Power BI | Microsoft Learn

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.