Date field changes to default value In Power BI

[lmessy]

We have some reports that we recently published from SSRS to Power BI, in the SSRS version, when a user selects the From date in the parameters the To date remains unchanged until the user changes it. In Power BI however, when the user changes the From date, the To date is automatically changed to a default date value. Can anyone help with how we can stop that from happening?

[v-zhouwen-msft]

Hi @lmessy ,

I don't have a clue at the moment as to why this is happening, perhaps you could use the 'CALENDAR' function to create a date dimension table to join with the fact table.