Enter Specific Date

Hi chrismoncrief 

Thank you for reaching out to the Microsoft forum community. Regarding your query about entering a specific date in Power BI, note that the feature to prompt users for a specific date (similar to [Enter Date] in Microsoft Access) is available only if your data source is in Direct Query mode. 
You can achieve this by: 

•  Creating a Parameter in Power Query: 
       Define a parameter for the date. 
       Use the parameter to filter your query. 
       When refreshing the data, Power BI will prompt the user to enter a date. 

Power BI does not have a direct "pop-up input" feature like Microsoft Access does, but you can achieve similar functionality by using parameters or what-if parameters combined with a slicer or filter. Here's how you can replicate the behavior of prompting the user for a date: 

If your data is in Import mode, direct prompts are not possible, but you can use the following alternatives: 

• Date Slicer: Add a slicer to the report for users to select a date interactively. 

• Custom Parameter Table: Create a small table of possible dates, connect it to your main table, and use a slicer for date input. 

• Power Apps Integration: Embed a Power Apps visual to capture user input dynamically. 

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly. 

Thank you