Forum Discussion
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.
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
- Creating a Parameter in Power Query:
4 Replies
Only possible if your data source is in Direct Query mode.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
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
- Creating a Parameter in Power Query:
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.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.
