Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Issue with Action Date/Time Display after implementing 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.

 

Here's a breakdown of the problem and the relevant data:


The table is related to tickets assigned by two people to different technicians. The "Action Date/Time" column is displaying the date and time when the ticket was returned by the technician to the person who can then either send it back to the technician or close it. In my Power BI report is not displaying the correct dates for occurrences of actions taken on tickets. Despite having the correct raw data, the displayed dates in the report after implementing the query editor are inaccurate.

 

Results in Power BI (Incorrect): 

 

Jack_Reacher_1-1712560511443.png

 

 

Any insights or suggestions on how to correct this issue would be greatly appreciated


 

 

4 REPLIES 4
Anonymous
Not applicable

Hi @Anonymous 

I'm not able to access the sample file and sample data due to some network restrictions. If possible, can you paste some snippet of sample data in the reply? Sorry for this inconvenience.

 

Best Regards,
Jing

Anonymous
Not applicable

Hello Jin, can you please try accessing the link again ?
https://drive.google.com/drive/folders/15OSktBbdm8rnZnSjzNilRWuz4tFpC3Pv?usp=drive_link

Anonymous
Not applicable

Unfortunately my network blocks some cloud file services and googledrive is one of them😥

Perhaps you can capture a screenshot to show how the raw data looks like (mask or remove sensitive data). Or paste some sample data of one or two tickets. I guess you are creating a table visual in the report and it seems to display one ticket at a time. So one or two tickets' data is probably enough. 

Anonymous
Not applicable

@Anonymous  Yes no worries, please try this  link https://app.nihaoconsult.com/u/d/5d8b0fe3fd9b4d5cb601/

Otherwise, you may find the screenshot below

Jack_Reacher_0-1712971637679.png

 





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.