Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
chrismoncrief
Frequent Visitor

Enter Specific Date

Hello

 

I am looking to see if there is a Power BI function that would allow the user to enter in a specific date to pull the data.

 

For example:  My query has a date for "Report Date", and looking to see if there is a way to require the user to input a date for the data to pull.  In Microsoft Access I would put in brackets [Enter Date] and a pop up would show asking the user to input a date.  Wondering if Power BI has the same function.

 

 

1 ACCEPTED SOLUTION
v-saisrao-msft
Community Support
Community Support

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 

 

View solution in original post

4 REPLIES 4
v-saisrao-msft
Community Support
Community Support

Hi @chrismoncrief 
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @chrismoncrief 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

v-saisrao-msft
Community Support
Community Support

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 

 

lbendlin
Super User
Super User

Only possible if your data source is in Direct Query mode.

 

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors