Date format changing between Dataset and Report

[HaakSander]

Hello,

*All activities are done in the Power BI Desktop app on the same device.

I have a dataset file with a particular query named 'ExistingCustomersPipeline'. This query has a property called 'properties.closedate' which indicates the close date of a deal. I have created a relationship between this and my date table. The datetable works correctly with different queries and does not seem to have this issue anywhere else. 

The strange thing is that in my Dataset file, the date property is formatted as my desired format (DD/MM/YYYY), however in the report it's formated as MM/DD/YYYY. The visual formatting itself isn't the main issue, but it means that the link between the properties.closedate property, and the calendar date property is effectively broken apart from a handful of dates.

Pic1: Deal X, Dataset file, table view, properties.closedate

Pic2: Deal X, Report file, same property only renamed for visual purposes

Are there any known issues or fixes that could explain this? 

[v-zhengdxu-msft]

Hi @HaakSander 

Is this Close date a measure?

You can double click the measure or select Measure tools to change the data type.

Best Regards

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

[HaakSander]

Hi! 

Thanks for the response! The property is not a measure, is that necessary? I have different Date properties from other tables linked to the 'Date' table, and none are measures.

Sidenote: Both screenshots in my initial message display the same property. In the report I have just renamed it to 'Close date' for visual purposes.