Forum Discussion
Dynamically Filter Data Based on User-Selected Date Range Beyond Imported Data
Hello,
Is there a way in Power BI to allow users to input a date range that extends beyond the original imported data, while still being able to retrieve and display data for the selected date range, even if it's outside the default range initially imported?
For instance, if the imported data covers a range from 01-08-2022 to 01-08-2023, and a user wants to select a date range like 01-08-2021 as the start date and 01-08-2023 as the end date, is there a method for Power BI to go back to the database and dynamically fetch and display the data for the user-specified date range, including data beyond the initially imported range?
2 Replies
Hello - users cannot query data that isn't included in the dataset. When you import the data, that is what the users are able to query for visualizations. You would have to adjust your model to import data for the additional year(s).
audreygerred Thanks for your response. I'm curious if achieving this is possible using Parameters or if DirectQuery mode is a viable option? Any insights or recommendations are welcome.
Thank you!
