Forum Discussion
Date Parameter not working as expected
It's possible that the issue is related to the data type of the date column in your second model. Power BI may not be recognizing the date column as a date data type, which could be causing the date range parameter to not work correctly.
To check the data type of the date column in your second model, go to the "Data" view in Power BI Desktop, select the table that contains the date column, and check the "Data Type" property of the date column in the "Column tools" pane on the right-hand side. If the data type is not set to "Date/Time", you can change it by selecting the column and then choosing "Date/Time" from the "Data Type" dropdown in the "Modeling" tab of the ribbon.
If the data type of the date column is already set to "Date/Time", another possibility is that there is a problem with the query that is being generated for the second model when you apply the date range parameter. You can try modifying the query manually to include a filter on the date column that corresponds to the date range parameter. To do this, go to the "Transform Data" view in Power BI Desktop, select the table that contains the date column, and click the "Filter Rows" dropdown in the "Transform" tab of the ribbon. From there, you can add a filter that restricts the date column to values within the selected date range. Once you've made the filter, you can click "Close & Apply" to apply the filter and load the data into your second model.
Best regards,
Isaac Chavarria
If I answered your question, mark it as a solution.