Forum Discussion

lmessy's avatar
lmessy
Frequent Visitor
2 years ago

Date field changes to default value In Power BI

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?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.