Date Format Bug

Question

I have a set of dates in the format DD/MM/YYYY.In my query they appear correct:However once I save and apply my Query they do not:

anonymous · Answer

Hey&nbsp;Anonymous&nbsp;I see same date formats in both screen shots. And it is dd/mm/yyyyMissing something?Cheers!A

anonymous · Answer

Well you are correct, but see how once the query is applied the dates get switched 6/XX/XXXX when in the query it didn't look like that at all.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;Try to add more collumns as reference.It just might be that the sorting order is different.&nbsp;Thanks!A

v-piga-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
Have you solved your problem?
If you have solved, please&nbsp;always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still have issue, I want to know more details below.
1. What data type for your date column? Date or Text?
2. What system date format do you use?
3. What about changing the locale like below.

If you still need help, please share a&nbsp;dummy pbix file which can reproduce the scenario, so that we can help further investigate on it?&nbsp;You can upload it to OneDrive and post&nbsp;the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
&nbsp;

Forum Discussion

Date Format Bug

4 Replies

Related content

Date format issue

DAX Query Format Date

conditional formatting: popup window: bugs

Date Display Formats

Date formatting